If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
IF Function
By "-" do you mean a minus number or an actual dash??
if(w140,"",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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|