How do I use Roundup in a logical test in excel

[Guest]

I am entering a formula using a logical test in Excel. I want the results to
always round up to the next whole number. I am not able to get the "Roundup"
function to work. Any help would be appreciated.

 

[Niek Otten]

What formula? What data? What results did you expect? What did you get
instead?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[JE McGimpsey]

Without your posting your formulae, it's impossible to help you with it
other than to say "look in Help".

Generally, you could wrap your existing formula with

=ROUNDUP(<existing formula>, 0)

Alternatively:

=CEILING(<existing formula>, 1)

 

[CLR]

Something like this maybe?
It will give you a blank cell if the result is an error.

=IF(ISERR(ROUNDUP(IF(A1>100,A1,""),0)),"",ROUNDUP(IF(A1>100,A1,""),0))

Replace the IF statement with your formula, both places.......

Vaya con Dios,
Chuck, CABGx3