Round off

[Chatbot]

I want numbers to appear in the below mentioned format

56.30 = 56
57.50 = 58
56.49 = 56
57.51 = 58

Using roundup, rounddown & round I can achieve desired functionality? Which is the best way to do this

When I perform addition and substraction on the converted cells it consider decimal places and show deviated result.

How can I get the desired results.

56+58+56+57 = 227 (CORRECT)
56.30+57.50+56.49+57.51=227.80(INCORRECT)

[ChemistB]

ROUND will bring numbers at .5 and higher up and .49 and lower down.

Are these numbers coming from a formula and you want to round them or are people entering them manually and you want them rounded at input? If the second, do you want them rounded in the cell they are inputted or can it be in an adjoining column?

[Chatbot]

they are coming from formula

[tigertiger]

Try to use Round( ...,0), like this
Assuming:
A1=36
A2=20.3
The result cell (B1), using the following formula:
=Round(A1+A2,0)

[martindwilson]

=SUMPRODUCT(ROUND(A1:A4,0))
56.30 = 56
57.50 = 58
56.49 = 56
57.51 = 58
gives total of 228 from above example