Rounding up and down

[Guest]

How do I write a formula that will allow me to round down to a whole number
if the decimal is equal to or less than .49 and round up to the next higher
whole number if the decimal is equal to or greater tthan .50? (Currency
formating)

 

[Frank Kabel]

Hi
=ROUND(A1,0)

 

[BenjieLop]

How do I write a formula that will allow me to round down to a whole
number
if the decimal is equal to or less than .49 and round up to the next
higher
whole number if the decimal is equal to or greater tthan .50?
(Currency
formating)

=round(A1,0) will work for you.