Jan 20 2022 02:55 AM
Jan 20 2022 03:10 AM
Perhaps you meant
=IF(AND(C2>C5,D2<D5),A2,IF(AND(C2<C5,D2>D5),B2,IF(AND(C2>C5,D2>D5),F2,IF(AND(C2<C5,D2<D5),C2*C5))))
or (if you have Excel 2019 or later)
=IFS(AND(C2>C5,D2<D5),A2,AND(C2<C5,D2>D5),B2,AND(C2>C5,D2>D5),F2,AND(C2<C5,D2<D5),C2*C5)
Please note that the formula will return FALSE if C2=C5 and/or D2=D5 since your conditions don't include that situation.