IF Function

[casdaq]

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.

 

[Don Guillett]

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

 

[Ron@Buy]

Try:
=IF(W14<=0,"",VLOOKUP($A14,$B$7:$J$10,5)*W14)

 

[casdaq]

THANK YOU THANK YOU THANK YOU!! That worked out perfactly!

 

[jayray]

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.