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))
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?
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))
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!!!