IF OR
I want to test the value of two columns, with a formula that says IF G10 OR
I10, put "Y" in T1. I have tried different variations of IF, OR, but
nothing works the way I want it to - T fills up with FALSE, or blanks.
=IF(G10,IF(I10,"Y",""))
This looks so simple, but I've hit a brain block!
TIA,
CaroleO
|