Forum Discussion
Excel if /then functions help
I am making a very simple spreadsheet, I believe except I am applying a value for a rank of a participant. For example if you rank #1 then you are assigned points of 4, if rank #2 then you are assign...
If you have Excel 365 then
= LET(
points, 5 - RANK(numbers, numbers),
IF(points>0, points, "")
)would return points according to rank. Without 365 removing the negatives is just a bit more ugly.