Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
ROUNDING RESULT OF CALCULATION UP OR DOWN | Excel Discussion (Misc queries) | |||
Prevent EXCEL from rounding the result of a calculation | Excel Discussion (Misc queries) | |||
Price calculation - rounding | Excel Discussion (Misc queries) | |||
rounding a calculation down to the nearest 0.5 - how? | Excel Discussion (Misc queries) |