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)




In article ,
"DC" wrote:

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.