how do I round up a result of a formula in Excel
 

I want to round up the result of a formula. When I try to use RoundUP to
format the formula I get a "circular" error. Suggestions?

how do I round up a result of a formula in Excel
 

The formula is probably referring to the cell that it is in. Post the
formula here then we will know.

Pete

how do I round up a result of a formula in Excel
 

Hi,

Make your formula to be a part of the roundup formula as follows:

=ROUNDUP(the formula you have now without the leading "=" sign,number of
digits you want the result to be rounded up)

For example, if your formula is =A2^3+B2^2+C2, the new formula would be
=ROUNDUP(A2^3+B2^2+C2,0); the result would be rounded up to the next higher
integer.

Regards,
B. R. Ramachandran

"one of two" wrote:

I want to round up the result of a formula. When I try to use RoundUP to
format the formula I get a "circular" error. Suggestions?