Rounding-up formula in Excel?

G

gfdaught

Greetings. I am wanting the decimal result of a calculation in a cell
to be rounded-up to the nearest whole number if the decimal place of
that result is .2 or greater. Can someone show me how I should set-up
the formula in the result cell? Thanks.

Gary
 
B

Barry N. Wainwright

Greetings. I am wanting the decimal result of a calculation in a cell
to be rounded-up to the nearest whole number if the decimal place of
that result is .2 or greater. Can someone show me how I should set-up
the formula in the result cell? Thanks.

Gary
Click to expand...

You posted this to the word group instead of the excel group, but I believe
the answer you require is:;

=(INT(A1+0.8))
(where 'A1' contains the decimal number to be rounded).

--
Barry Wainwright
Microsoft MVP (see http://mvp.support.microsoft.com for details)
Seen the Entourage FAQ pages? - Check them out:
<http://www.entourage.mvps.org/toc.html>

Please post responses to this newsgroup. If I ask you to contact me
off-list, remove '.INVALID' from email address before replying.
 
Top