Nested IF formula

[stark76]

Hi
I have a nested IF string that is not calculating, any help would be greatly appreciated.

=IF((AND(B5=AE12,AE13,AE18,AE19,AE25,AE26,E8>=2.251,E8<=2.55)),12,0)

 

[stark76]

Re: Help with nested IF formula

Hi Scott
Thank's for the evaluation tip and your above solution.
Unfortunately its still not quite there.

I've manually evaluated the formula arguments and all seem to test ok, however it is not returning the desired result.
Could there be too many arguments, or should I try a different approach?

Essentially I need the formula to check cell B5 for a match in either cell AE12, or AE13, or AE18, or AE19, or AE25, or AE26
If true the check the cell value in E8 to see if the number is between 2.251 & 2.55
If the number in E8 is within the specified range, then return 12, else 0

 

[Joe4]

Re: Help with nested IF formula

Essentially I need the formula to check cell B5 for a match in either cell AE12, or AE13, or AE18, or AE19, or AE25, or AE26
If true the check the cell value in E8 to see if the number is between 2.251 & 2.55
If the number in E8 is within the specified range, then return 12, else 0

Slight modification to my formula:

[COLOR=#333333]=IF(AND(OR(AE12=B5,AE13[/COLOR][COLOR=#333333]=B5[/COLOR][COLOR=#333333],AE18[/COLOR][COLOR=#333333]=B5[/COLOR][COLOR=#333333],AE19[/COLOR][COLOR=#333333]=B5[/COLOR][COLOR=#333333],AE25[/COLOR][COLOR=#333333]=B5[/COLOR][COLOR=#333333],AE26[/COLOR][COLOR=#333333]=B5)[/COLOR][COLOR=#333333],E8>=2.251,E8<=2.55),12,0)[/COLOR]

 

[stark76]

Re: Help with nested IF formula

I was wondering if a "or" argument could be added,
thanks Joe4 it works perfectly

 

[Joe4]

Re: Help with nested IF formula

You are welcome.

Yes, you have to use a combination of both because what you have is if any one of the first checks is true (for your B5 check), AND all the E8 checks must be true.
I hope that it all makes sense by inspecting the formula.