Nesting IF

[Nanaia]

I have 4 formulas that work independently. Two are similar to the other two in what they look for. I'm trying to put them all into one formula. How do I nest them so that if Excel finds #1 , it doesn't look for #2 , and if it finds #3 it doesn't look for #4 ? It would never find #1 and #3 at the same time, nor will it ever find #2 and #4 at the same time, because B2 will only be either "H" or "V" and C2 will only be Zinc or our standard material.

#1 is (=IF(AND(B2="H",$C$2="ZINC"),(COUNTIF('EDGES & BEND ALLOWANCE'!$AA$2:$AA$318,E2)>0)))
#2 is (=IF(B2="H",(COUNTIF('EDGES & BEND ALLOWANCE'!$Y$2:$Y$318,E2)>0)))
#3 is (=IF(AND(B2="V",$C$2="ZINC"),(COUNTIF('EDGES & BEND ALLOWANCE'!$AC$2:$AC$318,E2)>0)))
#4 is (=IF(B2="V",(COUNTIF('EDGES & BEND ALLOWANCE'!$Z$2:$Z$305,E2)>0)))

On a side note, where would I find classes on this stuff so I'm not always harassing you fine people?

 

[steve the fish]

They are fairly simple to build. Click the 2nd formula. In the formula bar highlight the formula not including the = sign. Press CTRL-C then ESC key. Now click into your 1st formula immediately after the IF. Click the fx button next to the formula bar. A dialog box appears. You will see you have no false argument. Click into the false box and press CTRL-V. Press enter and agree with excel correcting the formula. There you have nested the 2nd formula into the first. Repeat but this time click into the formula immediately after the 2nd IF. You will know you are right because the IF will have no false argument.

 

[Nanaia]

Cool! Thanks! That enabled me to nest those two. How to I merge the two nested ones I just created so I have one formula?

 

[steve the fish]

So you have nested the 2nd one into the first one? Yes? So click into that formula. Click after the 2nd IF. Click the fx button. The false part should again be empty. So you just need to copy the formula required to be pasted into here like you did before.

 

[Nanaia]

Sweet! Thank you! I appreciate you telling me how to do it myself instead of relying on someone else!