| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with a SUM formula...
That makes alot of sense. Thank you!
"Ron Rosenfeld" wrote: On Thu, 15 Nov 2007 12:07:00 -0800, Christina wrote: Here's the formula I'm using: =IF(E280,"25",IF(E28=0,-)) The formula is doing exactly what it should. I just want the 25 added into the sum when applicable. Thanks! Christina As was pointed out by many, when your IF formula is returning TEXT rather than a number. If you enclose a value within double quotes, that value is TEXT, and not a NUMBER. SUM function ignores TEXT, so will not add it. If you want the result of your IF function to be treated as a number, you must have it return a number. e.g.: =IF(E280,25,IF ...) --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
