Formula will not copy correctly

I have a very simple if formula that will not copy correctly. I would like the cell to display a "-" if another cell contains a value and stay blank if the same cell is blank. I've used this formula =IF(K2>-1,"-",IF(K2="","")) which worked just fine previously, but when I dragged it down through the column it would just show the "-" regardless of whether K2 had a value or not. Now even the original cell is showing "-" when the value in K2 is deleted. I have already made sure that the calculation method is set to "automatic". I'm sure it is something silly. Thanks in advance for the help.

Does the cell still show the formula when you select it?

=IF(K2="","","-")

Yes it does

Actually, "-" for an empty cell would be correct, an empty cell has a numeric value of 0 and 0>-1 is true.

No formula just a value. In this case it's a dollar amount. I want it to display a dash in a column between two dollar amounts, so it will show $150 - $200. $150 would be K2 the if formula L2 and $200 M2.

Originally Posted by Bleveck90

No formula just a value. In this case it's a dollar amount. I want it to display a dash in a column between two dollar amounts, so it will show $150 - $200. $150 would be K2 the if formula L2 and $200 M2.

Try

=IF(COUNT(K2,M2)=2,"-","")

See my previous post for a reason why your formula didn't work properly.

Originally Posted by jason.b75

Try

=IF(COUNT(K2,M2)=2,"-","")

See my previous post for a reason why your formula didn't work properly.

Works perfectly. Thank you.