Roundup

H

Hakan D

I want to use roundup formula in a few different rows in
a worksheet, anything above .30 will be round up to next
nearest number such as 14.30 will appear as 15 whilst
14.29 will appear as 14. (Decimal places will be 0)Is
this possible ? Can I put this formula in format/cell or
Do I have to use different rows ? your help is
appreciated.
 
J

Jason Morin

One way:

=INT(A1)+(MOD(A1,1)>=0.3)

A little longer:

=INT(A1)+(MOD(A1,INT(A1)+0.3)<A1)

HTH
Jason
Atlanta, GA
 
K

K.S.Warrier

Hi,
Try this,
Suppose A1=14.30,then put B1=Int(A1,1)+if(mod(A1,1)<=.29,0,1)
Thank you,
K.S.warrier
 
Top