IF Function
 

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.

IF Function
 

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.

IF Function
 

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

"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.

IF Function
 

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

"Ron@Buy" wrote:

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

"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.

IF Function
 

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.