| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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),"") |
|
#2
|
|||
|
|||
|
How do I set up an IF function with text and numbers?
Thx Hrln, u hv a way w brvty <g
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert text numbers to numbers | Excel Worksheet Functions | |||
| convert numbers to text | Excel Discussion (Misc queries) | |||
| numbers to text function | Excel Worksheet Functions | |||
| Converting Numbers to Text properly | Excel Discussion (Misc queries) | |||
| how to format numbers stored as text or vice versa to use vlookup | Excel Worksheet Functions | |||
Hybrid Mode
