Roundup Function
 

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

Roundup Function
 

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

--
Kind regards,

Niek Otten

"Will" wrote in message
...
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

Roundup Function
 

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

Roundup Function
 

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

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