My goal is to simplify this formula. The problem is, I have limited knowledge of Excel. So I rely on the If logical operators. And, as consequence, the if formula is quite long for just 1 column.

The overview:

The current formula:

=IF(G10<C$3,F10>D$3,  IF(G10<C$4,F10>D$4,  IF(G10<C$5,F10>D$5,  IF(G10<C$6,F10>D$6,  IF(G10>C$7,F10>D$7)))))

CodePudding user response：

Just thought of another idea:

=INDEX(IF(F11:F<>"",LOOKUP(G11:G,C3:C7,D3:D7)<F11:F,""))

This will now spill-down results and will update these when you add more data.