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...
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";""))))))));"");"")