Roundup Function

W

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
 
N

Niek Otten

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

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
[email protected]
[email protected] with @tiscali.co.uk
 
W

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
 
Top