On May 21, 12:10*pm, casdaq wrote:
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.

Put SUM(W14) instead of just W14.