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))
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?
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))- YES IT WORKED!!! Thank you soooo much!!!! This is exactly what I was trying to do!!!