Forum Discussion
Formula Help - IF/OR/AND
- Mar 11, 2024
Formula in cell N4 and filled down:
=INDEX($D$10:$D$15,MATCH(1,(J4>$B$10:$B$15)*(J4<=$C$10:$C$15),0))
Formula in cell O4 and filled down:
=INDEX($D$10:$D$15,MATCH(1,(K4>$E$10:$E$15)*(K4<=$F$10:$F$15),0))
You can try these formulas. Enter the formulas with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
- John23785Mar 11, 2024Copper Contributor
This worked very well! I have office 365 but this solution was quick and easy, thank you SergeiBaklan . Question, If I were to have 4 arrays A-D, with different respective percentiles, is there a way to merge them? If A=A then score or if not then go to B-D?
- SergeiBaklanMar 11, 2024MVP
John23785 , you are welcome.
Afraid I didn't catch what A=A means, perhaps you may clarify on the sample.
- John23785Mar 12, 2024Copper Contributor
SergeiBaklan I believe I figured it out with a series of nested If statements, appreciate your help