| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excel formula calculations are wrong
typical:
Cell A1 I have 0.2 Cell B1 I have 0.22 Cell C1 I have formula : +(B1-A1), and the answer is 0.02, correct However, in Cell D1, I have a formula: +Power(c1,2), and the answer is 0.0005, WRONG, The correct answer is of course 0.0004, but all simailar calculations are in error. I even put in the formula for D1 as +(c1*c1) and I still get the same WRONG answer. Please advise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How wrong can you be with your NPV and MIRR functions in EXCel | Excel Worksheet Functions | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| In excel the formula bar behaves differently on different machines | Excel Discussion (Misc queries) | |||
Threaded Mode
