I would like to know how to round numbers down in excel 2003
Example
when I format a cell like this 1000/6.7 the answer is 149.2537 that is ok and the cell will show 149 which is what because I have deleted the decimal point.
but if for example I had 3 cells with the same equastion in them and another cell with a total, the total instead of being 149 times 3 equals 447 I get 448 because the sum is 149.2537 times 3 so the cell rounds up I do not want the cell to round up I want the answer matching what the cell displays 149 times 3 equals 447
Can you help please
please email me at mike.barnes@live.com
many thanks Mike
You have a few options
1 - you can use "Precision as Displayed" option - but this is not generally advised
http://support.microsoft.com/kb/214118
2 - you can adjust either your 3-cells or your "final calculation" to use only the Integer value of each.
In terms of adjusting the 3 cells directly:
=INT(1000/6.7)
or
=ROUNDDOWN(1000/6.7,0)
or
=FLOOR(1000/6.7,1)
*FLOOR is useful where the significance is something other than 1,10 etc...)
In terms of leaving those three cell as they were and adjusting only the final calculation:
=SUMPRODUCT(INT(A1:A3))
where A1:A3 are the three cells in question.
On a final note: please PM a Moderator and ask your thread be moved to an appropriate forum.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks