ROUNDUP

[Patti W]

Does anyone know how to "roundup" the results of a
calculation? i.e. =E54*(1+20%) I can get it to roundup
on this type of function: =ROUNDUP(E49*H42,-1). But in
the first example, my results is a number increased by
20% and then I need to round up to the nearest 10th.
Thanks for any help you can provide.

 

[Paul]

Does anyone know how to "roundup" the results of a
calculation? i.e. =E54*(1+20%) I can get it to roundup
on this type of function: =ROUNDUP(E49*H42,-1). But in
the first example, my results is a number increased by
20% and then I need to round up to the nearest 10th.
Thanks for any help you can provide.

Is this what you want?
=ROUNDUP(E54*(1+20%),1)

 

[Guest]

Paul, I tried your example below and received a "Circular
Reference" error. Am I doing something wrong?

Thanks.

 

[Guest]

Thanks for your help, Paul. I figured out why I had the
circular reference error.

--Patti

 

[Ron Rosenfeld]

Does anyone know how to "roundup" the results of a
calculation? i.e. =E54*(1+20%) I can get it to roundup
on this type of function: =ROUNDUP(E49*H42,-1). But in
the first example, my results is a number increased by
20% and then I need to round up to the nearest 10th.
Thanks for any help you can provide.

Use the CEILING function.

=CEILING(E49*H42,0.1)

--ron

 

[Ron Rosenfeld]

Does anyone know how to "roundup" the results of a
calculation? i.e. =E54*(1+20%) I can get it to roundup
on this type of function: =ROUNDUP(E49*H42,-1). But in
the first example, my results is a number increased by
20% and then I need to round up to the nearest 10th.
Thanks for any help you can provide.

OR

=CEILING(E54*(1+20%),0.1)


--ron