Nesting If Statements

[Steve G]

Hi -

I am trying to nest 3 IF statements into one, however it's not working very well. The formulas look the same, but with some varaiton to achieve the constraints I need for this project. Here are the three IF statements I need to roll into one (if possible)

IF(and(B5>710,B5<=2200,VLOOKUP(A5,Hol_Table,2,FALSE)="N"),SUM(C3:C5)/3,

IF(and(B5>705,B5<=710,VLOOKUP(A5,Hol_Table,2,FALSE)="N"),SUM(C4:C5)/3,

IF(and(B5>700,B5<=705,VLOOKUP(A5,Hol_Table,2,FALSE)="N"),C5/3,

If anyone out there can help me, it be a life saver! Thank you

Stev

 

[Frank Kabel]

Hi
not tested but try:
=IF(VLOOKUP(A5,Hol_Table,2,FALSE)<>"N",0,IF(AND(B5>710,B5<=2200),SUM(C3
:C5)/3,IF(and(B5>705,B5<=710),SUM(C4:C5)/3,IF(and(B5>700,B5<=705),C5/3,
0))))

--
Regards
Frank Kabel
Frankfurt, Germany

Hi --

I am trying to nest 3 IF statements into one, however it's not

working very well. The formulas look the same, but with some varaiton
to achieve the constraints I need for this project. Here are the three
IF statements I need to roll into one (if possible).