Roundup Function

[Will]

This will probably be an easy question, but I can't figure it out. I
want to round up a cell that contains a formula.

Ex. =E4*C7

Where E4 = 1.53%
C7 = .74
I am currently using this formula: =ROUNDUP(E4*C7,2)

Shouldn't the answer be .02?

Thank you,
....Will

 

[Niek Otten]

Probably, because it is.....here. What do you get? Look at the formatting of
your cell.

 

[Guest]

your formula should be
=ROUNDUP(+E4*C7,2)
there should be a + in front of the E4

 

[Sandy Mann]

there should be a + in front of the E4
Why? It works for me without the + and I believe that it is not required.



To Will:

Is the entry in either E4 or C7 the result of a calculation? It may be that
it is displaying as say 0.74 but the value held in the cell is actually a
different
value. What result are you getting returned?
--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Will]

Hi Sandy,
Neither entries in E4 or C7 are the result of calculations. My result was
originally .01. I am now getting .02.
Thanks to all who helped.
....Will