rounding

J

joe

i am using an "IF" function. If the value is "TRUE", I need it to use the
value but round it up to the next highest whole integer. How do I do that?
 
J

John

try =IF(A1,ROUNDUP(A1,0))
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)
 
S

Sandy Mann

Joe,
i am using an "IF" function.
Click to expand...

Do you mean that you are already using an IF() function or you want to use
an IF() finction?
I'm going to assume that you want an IF() function.

Try:
=IF(F3>50,ROUNDUP(F3,0),F3)
or
=IF(F3>50,INT(F3)+1,F3)
or
=IF(F3>50,CEILING(F3,1),F3)
take your pick and adjust to suit your needs.

If you mean something different the post back with more details.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
Top