If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calculating percentages
The following problem was encountered by one of my
students. She uses two formulas to calculate percentages from a cost. But sometimes it's off by a few cents which can throw grand totals way off in the end. What would be a better way to calculate more accurate percentages? |
#2
|
|||
|
|||
Since you don't say whether the result is too high or too low, and you don't
give the formulas you are using, it's difficult to comment on what might be a better way. Try this: Make a copy of the spreadsheet, open the copy, and click on Tools | Options | Calculations | uncheck the "Precision as displayed" box (or check the box if it's currently unchecked). Does this yield results that are closer to the expected ones? "Carol" wrote: The following problem was encountered by one of my students. She uses two formulas to calculate percentages from a cost. But sometimes it's off by a few cents which can throw grand totals way off in the end. What would be a better way to calculate more accurate percentages? |
#3
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/pennyoff.html In article , "Carol" wrote: The following problem was encountered by one of my students. She uses two formulas to calculate percentages from a cost. But sometimes it's off by a few cents which can throw grand totals way off in the end. What would be a better way to calculate more accurate percentages? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating percentages per group | Rich | Worksheet Functions | 3 | August 3rd, 2004 07:49 PM |
Problems caused by numbers formatted as percentages | Leslie | Worksheet Functions | 2 | May 8th, 2004 12:46 PM |
Calculating Percentages | Michael | Worksheet Functions | 0 | April 22nd, 2004 12:05 AM |