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?
- I didn't explain well and I don't know you data either. So in abstract terms I see:
IF( it is after 5pm, go home, otherwise stay at work)
IF( I'm tired, go to sleep, otherwise go to gym)
now combine them
well do I only do the 2nd if I go home? how do I combine those conditions?- I see what you mean. I think I'm trying to say:
IF (it is 5PM AND dark at night, go home, otherwise stay at work)
OR
IF (if it is not 5PM AND daylight, go home, otherwise stay at work)
Is it possible to combine?- 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))