I have the below formula but for some reason it's giving me an error and I can't understand why.
Just to give you an idea of what I'm trying to do, cell J23 is a drop down list that refers to a table on the same sheet that I'm working on, that can either be 'Victory', 'defeat' or empty. What I want is that if J23 is either Victory or defeat, the cell with formula would remain empty but if it is empty, I want the formula to check if K23 is empty or not. If K23 is empty the cell with the formula would remain empty, but if there is a name in cell K23, I want that name in K23 to be displayed in the cell with the formula. Can someone please explain why I have an error? Thanks in advance
=IF(OR($J23="Victory",$J23="Defeat"),"",IF($K23="","",$K23))
Bookmarks