Thread: Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default Formula

=round(a1+b1,0)
or:
=roundup(a1+b1,0)

"sdmccabe" wrote:

The formula that exists in the cell is =(a1+b1). How would I add the round
formula?

"Nikki" wrote:

if your number is in cell A1, use =round(A1,0).

nikki

"sdmccabe" wrote:

I want to round up the result of a formula. What can I add to the existing
formula to accomplish this?