Excel 2007
It's early for a Sunday morning and my brain is not fully awake.
I'm having trouble with the following formula:
=IF(D6(T),IF(E6=D6,1,O),"")
Basically, I'd like Excel to determine if there's text in cell D6:
If true, then compare CELL C6 with D6, if they match, the cell with the formula will display a 1. If they don't match, the cell will display 0 (zero).
If false, display nothing.
Thanks in advance.
It's early for a Sunday morning and my brain is not fully awake.
I'm having trouble with the following formula:
=IF(D6(T),IF(E6=D6,1,O),"")
Basically, I'd like Excel to determine if there's text in cell D6:
If true, then compare CELL C6 with D6, if they match, the cell with the formula will display a 1. If they don't match, the cell will display 0 (zero).
If false, display nothing.
Thanks in advance.