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.

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

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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

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.

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

=IF(ISERR(ROUNDUP(IF(A1100,A1,""),0)),"",ROUNDUP( IF(A1100,A1,""),0))

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

Vaya con Dios,
Chuck, CABGx3



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