Forum Discussion
Need help with IF formula in excel
Hello!
If it’s possible then someone can help with the formula? I need to get rank based on several criteria. Correct ranks is showed in F column. I need to build one formula. A2 must be “OK” or “OK1” if not then “”. If B2 is in F column, then “”. And if not then based on e2 value get rank from L column.
If it’s possible then someone can help with the formula? I need to get rank based on several criteria. Correct ranks is showed in F column. I need to build one formula. A2 must be “OK” or “OK1” if not then “”. If B2 is in F column, then “”. And if not then based on e2 value get rank from L column.
- Got by myself. Thanks! =IF(OR(A5="OK";A5="OK1");IF(IFNA(MATCH(B5;J5:$J$14;0);"0")="0";IF(AND(C5*D5=1000;C5*D5=2000;C5*D5=5000;C5*D5=10000;C5*D5=20000;C5*D5=40000;C5*D5=60000);"1";""))))))));"");"")
