Hi, I could use some help. I saw lots of answers on how to round down when a
cell has a function in it (like IF, SUM), but how do you do it with a mere
calculation?

This is the data
c5 d5 e5
2.50% 25 =d5*c5

How do I round the result down to 2 digits? I tried using the ROUNDDOWN
function, bul all I get are errors. I used this forumula
=ROUNDDOWN((e5,2)d5*c5)) and got the errors.

I am in Excel 2003, by the way.

Perhaps you meant to do this
In E5: =ROUNDDOWN(D5*C5,2)
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Sally Sibthorpe" wrote:
Hi, I could use some help. I saw lots of answers on how to round down when a
cell has a function in it (like IF, SUM), but how do you do it with a mere
calculation?

This is the data
c5 d5 e5
2.50% 25 =d5*c5

How do I round the result down to 2 digits? I tried using the ROUNDDOWN
function, bul all I get are errors. I used this forumula
=ROUNDDOWN((e5,2)d5*c5)) and got the errors.

I am in Excel 2003, by the way.

Round down to 2 digits? Do you mean 2 decimals? Have you tried formatting
the cell(s) to a number with 2 decimals? HTH Otto

"Sally Sibthorpe" wrote in message
...
Hi, I could use some help. I saw lots of answers on how to round down
when a
cell has a function in it (like IF, SUM), but how do you do it with a
mere
calculation?

This is the data
c5 d5 e5
2.50% 25 =d5*c5

How do I round the result down to 2 digits? I tried using the ROUNDDOWN
function, bul all I get are errors. I used this forumula
=ROUNDDOWN((e5,2)d5*c5)) and got the errors.

I am in Excel 2003, by the way.

The syntax of the ROUNDDOWN function is shown in Excel help.
--
David Biddulph

"Sally Sibthorpe" wrote in message
...
Hi, I could use some help. I saw lots of answers on how to round down
when a
cell has a function in it (like IF, SUM), but how do you do it with a
mere
calculation?

This is the data
c5 d5 e5
2.50% 25 =d5*c5

How do I round the result down to 2 digits? I tried using the ROUNDDOWN
function, bul all I get are errors. I used this forumula
=ROUNDDOWN((e5,2)d5*c5)) and got the errors.

I am in Excel 2003, by the way.