| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
wrong calculation in excel? formula outcome < cell value??
I have A1:A4 cells filled with -1,2,3,4 and named the range A1:A4 "sales"
in A6 I have =SUM(IF(sales0,sales)) outcome 8 (=-1+2+3+4) and it should be 2+3+4=9 When I click the Fx button to edit the formula, the outcome is correctly shown as 9 ? Can anybody tell me what I am doing wrong here? I am using excel 2003 SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| On excel, my formula will not calculate and add info into cell | Excel Worksheet Functions | |||
| How do I see the formula calculation used in Excel functions box | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
Threaded Mode
