S
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
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