Using roundup on a cell with a formula

[sue]

Hi,

My cell has the following forumula:

=sum(H15-H12)/H11

I would like to use Roundup on the result - can you show me the syntax please.

Thanks,
Sue

 

[JE McGimpsey]

Hi,

My cell has the following forumula:

=sum(H15-H12)/H11

I would like to use Roundup on the result - can you show me the syntax please.

FIrst, in

SUM(H15-H12)

the SUM() function is unnecessary, just use

=(H15-H12)/H11

To use ROUNDUP():

=ROUNDUP((H15-H12)/H11,x)

where x = -2, -1, 0, 1, 2, 3, etc. depending on how many decimal places
to round to (e.g., 0 will round up to the nearest integer, 1 to the
nearest 10th, -2 to the nearest hundred, etc.).

You can also find the syntax in XL Help ("ROUNDUP" topic).