Forum Discussion
Solved
Please Help to find the formula
Hi,
Try one of these formulas:
=IF(OR(ISNUMBER(MATCH(F3,$A$3:$A$9,0)),
ISNUMBER(MATCH(G3,$B$3:$B$9,0)),
ISNUMBER(MATCH(H3,$C$3:$C$9,0))),"done","")=IF(SUMPRODUCT(--(F3:H3=$A$3:$C$9)),"done","")
Hope that helps
Hello, us =IF(logical_test,value_if_true,value_if_false)
Logical_test: is any value or expression that can be evaluated to TRUE or FALSE.
Value_if_true: is the value that is returned if Logical_test is TRUE. If omitted, TRUE is returned. You can nest up to seven IF functions.
Value_if_false: is the value that is returned if Logical_test is FALSE. If omitted, FALSE is returned.
