Nested If Statements

[SirHart]

Hey everyone,

This site has been so helpful so far. I have another one for you.

I need to nest if(iserror) statements. I tried to nest it on my own but I am continuously getting errors. I'm banging my head against a wall here.

Here's the rundown.

The original statement is

=IF(ISERROR(SEARCH("xx",AZ$8)),"","Post Date")

That works perfectly, however; I need it to have additional options as well.

If Cell BA$8 has the xx, I want the text to read "Interview".
and
If Cell BB$8 has the xx, I want the text to read "Status"
(Don't worry about anymore than 1 cell having the "xx" at the same time, BUT I do need it to read the additional options! I am having a table that places itself in a certain place when the xx is there but the xx can change. So I just need to figure out how to nest these!)

This is my current failed attempt:

=IF(ISERROR(SEARCH("xx",AZ$8)),"","Post Date",IF(ISERROR(SEARCH("xx",BA$8,1)), "", "Inter view",IF(ISERROR(SEARCH("xx",BB$8,1)), "", "Status")))

Help a poor guy out!

 

[T. Valko]

Hey everyone,

This site has been so helpful so far. I have another one for you.

I need to nest if(iserror) statements. I tried to nest it on my own but I am continuously getting errors. I'm banging my head against a wall here.

Here's the rundown.

The original statement is

=IF(ISERROR(SEARCH("xx",AZ$8)),"","Post Date")

That works perfectly, however; I need it to have additional options as well.

If Cell BA$8 has the xx, I want the text to read "Interview".
and
If Cell BB$8 has the xx, I want the text to read "Status"
(Don't worry about anymore than 1 cell having the "xx" at the same time, BUT I do need it to read the additional options! I am having a table that places itself in a certain place when the xx is there but the xx can change. So I just need to figure out how to nest these!)

This is my current failed attempt:

=IF(ISERROR(SEARCH("xx",AZ$8)),"","Post Date",IF(ISERROR(SEARCH("xx",BA$8,1)), "", "Inter view",IF(ISERROR(SEARCH("xx",BB$8,1)), "", "Status")))

Help a poor guy out!

How about this...

=IF(COUNTIF(AZ$8,"*xx*"),"Post Date",IF(COUNTIF(BA$8,"*xx*"),"Inter view",IF(COUNTIF(BB$8,"*xx*"),"Status","")))

 

[jasonb75]

Try

=if(counta(AZ8:BB8),choose(match("xx",AZ8:BB8,0),"Post Date","Interview","Status")),"")

 

[SirHart]

Thank you T.Valko. That works like a charm. I would have never thought to do that in a million years.

Jasonb75, I got an error when trying yours...

 

[jasonb75]

I made an assumption that would appear incorrect,

=if(countif(AZ8:BB8,"xx"),choose(match("xx",AZ8:BB8),"Post Date","Interview","Status")),"")

or

=choose(countif(AZ8:BB8,"xx")+1,"","Post Date","Interview","Status")

but I don't think the latter will work for you.

 

[T. Valko]

Thank you T.Valko. That works like a charm. I would have never thought to do that in a million years.

You're welcome. Thanks for the feedback!