| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
IF Function returns False instead of 0
I must be going blind.
The first statement returns a "false" when not equal Likewise the second. The third returns a zero (0). I need a Zero from each one (if applicable), instead of "false". What am I overlooking. I'm thought I've used this satisfactorily before, but I'm stuck now. =IF(C6=E11,IF(C5=D11,IF(C3<=28,F11,0))) Thanks in advance. |
|
#2
|
|||
|
|||
|
One way
=IF(C6<E11,0,IF(C5<D11,0,IF(C3<=28,F11,0))) Regards, Peo Sjoblom "BEEJAY" wrote: I must be going blind. The first statement returns a "false" when not equal Likewise the second. The third returns a zero (0). I need a Zero from each one (if applicable), instead of "false". What am I overlooking. I'm thought I've used this satisfactorily before, but I'm stuck now. =IF(C6=E11,IF(C5=D11,IF(C3<=28,F11,0))) Thanks in advance. |
|
#3
|
|||
|
|||
|
Works like a dream.
Thanks much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Grouped Sheets and Formating | Excel Discussion (Misc queries) | |||
| Grand Totals @ Same Place | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
