Rounding up and down

J

Joe Dunright

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)
 
B

BenjieLop

Joe said:
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)
Click to expand...


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