| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
No value returned in if statement
I don't think there are any problems in this "if" statement, but it's not
returning any values; it just shows the entire formula in the cell. =IF(E18<0,"=sum(c24-e17)-c17","=sum(c24-c17)") When I test the statements separately, they come back with a value just fine. I even tried deleting the =sum in the formula thinking there should only be one = sign at the beginning of the formula, but that didn't work. It doesn't give me the #VALUE message either indicating something is wrong in this formula. Any ideas?? Oh yeah....I'm using Office 2000. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
| Summing Returned Positions using MATCH | Excel Worksheet Functions | |||
Threaded Mode
