I am using this formula in a spreadsheet =IF(AND(A2<>"",K2<>""),"CLOSED",IF(A2="","TO BUY","TO SELL"))

When the line is empty, the cell with this formula in displays "TO SELL". I would like it to display CLOSED until something is entered in either A2 (when it would display "TO SELL") or when something is entered in K2 (when it would display "TO BUY").

Any help on adjusting this formula would be appreciated.

Thanks,

Ant