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...
In E2:
=IF(($A2<>"")*($A2<F$1)*($B2>=E$1), 3, IF(($C2<>"")*($C2<F$1)*($D2>=E$1), 4, ""))
Fill to the right and down.