Forum Discussion
Trying to create a box plan with multiple IF functions
Hello all, Here's a spreadsheet that I'm trying to create at the moment. I have taken a formular from another sheet I have access to and it basically works. However... On the above I want to...
Try this:
=IF(OR($A2="", $C2=""), "", IF(OR(AND($A2<E$1, $B2>E$1), AND($A2>E$1, $A2<F$1)), 3, IF(OR(AND($C2<E$1, $D2>E$1), AND($C2>E$1, $C2<F$1)), 4, 0)))