Rounding down with a calculation
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. |
Rounding down with a calculation
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. |
Rounding down with a calculation
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. |
Rounding down with a calculation
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. |
All times are GMT +1. The time now is 10:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com