Thread
:
Rounding up and down
View Single Post
#
2
Frank Kabel
Posts: n/a
Hi
=ROUND(A1,0)
--
Regards
Frank Kabel
Frankfurt, Germany
"Joe Dunright" <Joe
schrieb im
Newsbeitrag ...
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)
Reply With Quote