how to roundup
 

How would I roundup in the following formula? I keep getting a circular
reference.

=E5*(1+10%)
E5 is constant

how to roundup
 

Roundup to what?

This rounds up to the nearest penny

=CEILING(E5*(1+10%),0.01)


Unless you have the formula in E5 you shouldn't
get circular reference if E5 is a constant

--


Regards,


Peo Sjoblom

"Trishs" wrote in message
...

How would I roundup in the following formula? I keep getting a circular
reference.

=E5*(1+10%)
E5 is constant

how to roundup
 

=ROUNDUP(E5*(1+10%),number_of_places_to_which_you_ want_to_round)

You won't get a circular reference unless you try to put the formula in cell
E5.
--
David Biddulph

"Trishs" wrote in message
...

How would I roundup in the following formula? I keep getting a circular
reference.

=E5*(1+10%)
E5 is constant

how to roundup
 

G'day Trish

Assumed

$A$1=100
B1=IF($A$1=0,0,$A$1*1.1)
Result = 110

HTH
Mark.