| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why do I get correct answers to formula then #NAME for some no's
I have an Excel worksheet with six separate columns of numbers and several
rows with numbers in one, several or all of the columns plus a total column. I am using a formula to crosscheck the totals. The formula being used is =IF(SUM(S4:S22)=SUM(B23:Q23),SUM(S4:S22),value). All of the numbers down and across (both positive and negative totals) add to a correct total in cell S23. Suddenly, by adding a negative number (within a range of -45 to -244) the answer becomes #NAME. Why?? By adding any other numbers (positive or negative) the crosscheck answer is correct. I have never had this problem with an Excel spreadsheet previously. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| One formula, many possible answers. | Excel Discussion (Misc queries) | |||
| using formula with several possible answers | Excel Worksheet Functions | |||
| Correct answers like a quiz | Excel Worksheet Functions | |||
| using a formula, no's 1-443 deleting (116-124) in serval cells | Excel Worksheet Functions | |||
| formula gives 2 different answers | Excel Worksheet Functions | |||
Threaded Mode
