How do i round up the sum of a formula

ian · May 28, 2006

I woul like to round up the sum of a formula

=K11+(M7*25%)

=115+(22*25%)=120.5 shouldshow 121

bgeier · May 28, 2006

The "0" determines the number of decimal places.

=ROUNDUP(115+(22*25%),0

Norman Jones · May 28, 2006

Hi Ian,

Try:

=ROUND(115+(22*25%),0)

See also the ROUNDUP and ROUNDDOWN functions in Excel help.