|
| 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
May 21st, 2010, 05:10 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
May 21st, 2010, 05:19 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
May 21st, 2010, 06:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
May 21st, 2010, 06:34 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
May 21st, 2010, 08:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 | |
|
|
Linear Mode
