| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
I want to check for a text value, not numerical
Can this be modified to check for a text value instead of a numerical (n6=1)?
=IF(J3<1,0,IF(N6=1,G6,D6)) I'm getting the results I want, but I would prefer to use a letter instead of a number. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assign numerical values to text codes | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Command: If the contents (text not numerical) of A1 in Sheet2 are. | Excel Worksheet Functions | |||
| How can I get text to equal a numerical value in Excel? | Excel Discussion (Misc queries) | |||
| Check if table contains text | Excel Worksheet Functions | |||
Threaded Mode
