Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding down | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) | |||
Rounding | Excel Discussion (Misc queries) | |||
Rounding | Excel Discussion (Misc queries) |