| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
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
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Hybrid Mode
