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

O

one of two

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?
 
P

Pete

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

Pete
 
B

B. R.Ramachandran

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
 
Top