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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
The formula is probably referring to the cell that it is in. Post the
formula here then we will know.

Pete
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

round a formula's result 2
Rounding in Excel 2
Rounding Up question 2
Combined ROUNDUP 5
Nested Formulas v Named Formulas Any other solutions? 10
round up 1
roundup with index,match,subtract,divide and add formula 3
how do i use the roundup function 6

Back
Top