Forum Discussion
Solved
combining IF statements
I'm trying to combine the following IF statements into 1: =IF(AND(B18<>$D$2, L18>=0), VLOOKUP(B18,$D$2:$E$5,2,FALSE),VLOOKUP(B18,$D$2:$F$5,3,FALSE)) & =IF(AND(B20=$D$2, L20>$F$2), VLOOKUP(B20,$D$2...
- Ahhh wait, this could be even easier than I thought. so quick question:
In the examples, will cell references B18 & L18 vs B20 & L20 become the SAME cells? If so then assuming everything for Row 18 then try:
=IF(OR( AND(B18<>$D$2, L18>=0), AND(B18=$D$2, L18>$F$2) ), VLOOKUP(B18,$D$2:$E$5,2,FALSE),VLOOKUP(B18,$D$2:$F$5,3,FALSE))
2 IF statements can be added/chained together but you need to decide how:
IF( condition1, true 1 result, IF( condition2, true 2 result, ...
in the example you gave both IF statements have both true and false calculations so what priority do you need to chain or waterfall the IF statements?
IF( condition1, true 1 result, IF( condition2, true 2 result, ...
in the example you gave both IF statements have both true and false calculations so what priority do you need to chain or waterfall the IF statements?
Thanks for the response! I would say the 2nd statement would take priority. How would that change the formula if I were to combine?