| 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. |
|
#2
|
|||
|
|||
|
=IF(J3<1,0,IF(N6="value",G6,D6))
-- HTH RP (remove nothere from the email address if mailing direct) "Xanadude" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
Thanx Bob
I had already tried that, not realising that another function was causing interferance with the expected output. It's almost straightened out now. (See follow up post) "Bob Phillips" wrote: =IF(J3<1,0,IF(N6="value",G6,D6)) -- HTH RP (remove nothere from the email address if mailing direct) "Xanadude" wrote in message ... 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. |
| Reply |
| 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 | |||
Linear Mode
