| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A correct formula gives an incorrect figure
I did find the error, there were numbers not showing, I went into options on
the tools area and checked calculations, and clicked precision as displayed "GarMcCas" wrote: In a payrol sheet I am adding a row of numbers calculating the amount paid in one month. There are 4 numbers all ending in 1. the formula I used to calculate is a very basic formula. It is =SUM(G10:G14). Instead of giving me the last number as 4, it gives me a 5. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| feel that the STANDARD DEVIATION formula on Excel is incorrect !! | Excel Worksheet Functions | |||
| Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
| Polynomial Formula Incorrect? | Charts and Charting in Excel | |||
Hybrid Mode
