nested conditional formulas

**Diane Kloecker** · 04-04-2007, 09:15 PM

I cannot seem to find the correct way to right my formula because of the 7 argument limit in "if" statements. I think I have a way around it but am not sure how to write it. I have 15 possible conditions and want 1 of 4 results. If I say
=if(g2="bend cell #1",or,"bend cell #2",or,"bend cell #3",or,"cold end #1",or"cold end #2",or,"cold end #3","uap1",if(g2="converter",or,"hot end #1 / underfloor",or,"hot end #2 / toeboard",or,"hot end diesel",or,"maniverter",or,"muffler cell #1","uap 2"))
I also have cells that belong to uap 3 and uap4. Am I using the "or" function properly?

**davesexcel** · 04-04-2007, 09:18 PM

Hi,
Could you zip an example workbook and attach it to your next post so that we could understand it better....

**Paul** · 04-04-2007, 10:17 PM

To use the IF(OR..) format, it looks like this might work for you:

=IF(OR(G2="bend cell #1", G2="bend cell #2", G2 ="bend cell #3", G2="cold end #1", G2="cold end #2", G2="cold end #3"),"uap1",IF(OR(G2="convertor", G2="hot end #1 / underfloor", G2="hot end #2 / toeboard", G2="hot end diesel", G2="maniverter", G2="muffler cell #1"),"uap2",IF(OR(G2="a", G2="b", G2="c", G2="d", G2="e", G2="f"),"uap3","uap4")))

Replace the "a", "b", etc. in the third condition with your values that you want to result in "uap3". If none of the first three conditions are met (uap1, uap2 or uap3), the formula will result in uap4.

nested conditional formulas

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

nested conditional formulas

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions