Rounding up and down
 

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)

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)

Joe Dunright Wrote:
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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=277055