I have this formula on a cell. It works if data on H3 is populated, otherwise, I get #Value!. I tried using ISERROR but it didn't work. I can't seem to figure out where the hold up is.
Can you help me?
Thanks in advance!
=IF((RANK(H3,$H$2:$H$4,0))=1," ",IF((RANK(H3,$H$2:$H$4,0))=2," ",IF((RANK(H3,$H$2:$H$4,0))=3,"Winner!"," ")))
See attached file too. I'm using 2003 version. Again, many thanks!
Bookmarks