Having some trouble with a part in an assignment which reads, "In cell B21, insert an IF function to determine which person had the lowest points. Assign 1 to the winner(s) and 0 to the other players. Be careful to correctly use relative and mixed cell references as needed in the nested function. Copy the function to the range C21:E21."
Hopefully the attachment works.
I tried using variations of the MIN and AND functions for the if statement but I'm still not getting it.
Bookmarks