How do I set up an IF function with text and numbers?
DOR wrote...
If the 7 nested IFs ever present a problem, this formula can be
extended beyond 7 columns,
=IF(ISNA(MATCH("X",F7:J7,0)),"",COLUMNS(F7:J7)+ 1-MATCH("X",F7:J7,0)) in
K7
....
You could shorten this to
=IF(COUNTIF(F7:J7,"X"),COLUMNS(F7:J7)+1-MATCH("X",F7:J7,0),"")
|