I want to check for a text value, not numerical

G

Guest

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

Bob Phillips

=IF(J3<1,0,IF(N6="value",G6,D6))


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To combine various cell formulae in to the final cell 1
Select which formula to use in a cell. 2
my first excel experience (share portfolio) 2
IF statement to check for numerical value 3
Returning 1 of 4 values if conditions are met 4
conditional statement using validation cell 2
Problems with IF, AND + OR statment 2
Return Cell Address of MIN value - array formula 5

Top