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.

=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.

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.