View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Will
 
Posts: n/a
Default Roundup Function

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