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)


"joe" wrote:

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?