rounding
 

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?

rounding
 

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?

rounding
 

Joe,

i am using an "IF" function.

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(F350,ROUNDUP(F3,0),F3)
or
=IF(F350,INT(F3)+1,F3)
or
=IF(F350,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


with @tiscali.co.uk


"joe" wrote in message
...
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?