By "-" do you mean a minus number or an actual dash??
if(w14<0,"",doyourthing)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"casdaq" wrote in message
...
I have this formula currently set up...

=VLOOKUP($A14,$B$7:$J$10,5)*W14

but I needit to not reflect the calculation if W14 has a "-" dash in the
cell. I've attempted to add in a If formula to this but it isn't working
out.

Any sugguestions are greatly appreciated.