How to round up the result in a cell containing formula
 

Is it possible to display the round up result of a formula in the same cell
containing the formula?
e.g.
a b c formula used
2.1 2.1 4.2 {=sum(a1:b1}
to be displayed as
a b c
2.1 2.1 5 {=needed formula}

Mostropovich,

Use =ROUNDUP(SUM(A13:B13),0)

And it will do the trick.
--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp

Thanks, it works fine. have a good day.

"cmart02" wrote:

Mostropovich,

Use =ROUNDUP(SUM(A13:B13),0)

And it will do the trick.
--
Regards
Robert
Find me at www.juliobattisti.com.br/forum/default.asp