View Single Post
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

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)