Can there be a third choice in an IF statement?

G

Guest

Good day: I am using the following formula to make choices for conditional
formatting in other cells. As it is, the "else" would be the result of an
entry of a US state abbreviation and would result in a 2 being placed in the
cell. The problem is that if the source cell is blank a 2 is returned. Is
there another way of expressing this so that a Canadian province abb =1, a US
state = 2 and a blank cell ="" null.
=IF(OR(C6={"NB","NS","NF","NL","PE","PQ","QE","ON","MB","SK","AB","BC"}),1,2)
 
K

Kevin H. Stecyk

kevin wrote...
Good day: I am using the following formula to make choices for conditional
formatting in other cells. As it is, the "else" would be the result of an
entry of a US state abbreviation and would result in a 2 being placed in
the
cell. The problem is that if the source cell is blank a 2 is returned. Is
there another way of expressing this so that a Canadian province abb =1, a
US
state = 2 and a blank cell ="" null.
=IF(OR(C6={"NB","NS","NF","NL","PE","PQ","QE","ON","MB","SK","AB","BC"}),1,2)
--
Click to expand...

Hi,

I think you are looking for this:

=IF(ISBLANK(C6), "",
IF(C6={"NB","NS","NF","NL","PE","PQ","QE","ON","MB","SK","AB","BC"},1,2))

(watch the line wrap),

Blank...""
Cdn...1
US...2

HTH

Regards,
Kevin
 

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

Conditional formatting based on if statement. 2
If >0, count various codes in a range on another sheet 8
Counting # of values in a group registration 1
returning blank cell in an if statement 2
ISBLANK in an IF statement 4
IF statement in formula 7
Is there a way to time stamp an entry in excel? 3
How do you display IF statement results in a different cell 3

Top