Hello,
I need help with a formula that returns either "WIN" or "LOSE" dependent on two calculations.
The first is =IF(A1>A2,"WIN","LOSE")
However, the second is =IF(AND(A1<>A2,B1>B2), "WIN","LOSE")
So I need the figures in column A prioritized unless they are equal, then check the figures in column B to determine the winner.
Sample attached.
Thanks in advance!
Dan
Bookmarks