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
Sandy Mann wrote:
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
with @tiscali.co.uk
"annie" wrote in message
...
your formula should be
=ROUNDUP(+E4*C7,2)
there should be a + in front of the E4
"Will" wrote:
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