Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional IF
I have this equation in the column E cells:
=IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)0,VLOOKUP(D3,$H $2:$I$17,2,FALSE)*C3,0) What I am trying to do is if there is no data in column D cells, I want it to enter a zero (0). It is currently returning the #N/A error, wich is the same error if I only had the vlookup () equation. I want it to return a zero (0) because at the bottom I am summing the content wich will return #N/A if one cell contains that message. Thanks for any help |
#2
|
|||
|
|||
Hey Hon,
Try this: =IF(D3="",0,IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)0,VL OOKUP(D3,$H$2:$I$17,2,FALSE)*C3,0)) Assuming that D3 has nothing in it this would give you a 0 in E3. HTH -Minitman On Thu, 28 Jul 2005 13:04:05 -0700, "Jon1205" wrote: I have this equation in the column E cells: =IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)0,VLOOKUP(D3,$ H$2:$I$17,2,FALSE)*C3,0) What I am trying to do is if there is no data in column D cells, I want it to enter a zero (0). It is currently returning the #N/A error, wich is the same error if I only had the vlookup () equation. I want it to return a zero (0) because at the bottom I am summing the content wich will return #N/A if one cell contains that message. Thanks for any help |
#3
|
|||
|
|||
Hi!
=IF(ISNA(VLOOKUP(D3,$H$2:$I$17,2,FALSE)),0,VLOOKUP (D3,$H$2:$I$17,2,FALSE)*C3) You can also use something like this to ignore the #N/A: =SUMIF(E1:E10,"<#N/A") Biff "Jon1205" wrote in message ... I have this equation in the column E cells: =IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)0,VLOOKUP(D3,$H $2:$I$17,2,FALSE)*C3,0) What I am trying to do is if there is no data in column D cells, I want it to enter a zero (0). It is currently returning the #N/A error, wich is the same error if I only had the vlookup () equation. I want it to return a zero (0) because at the bottom I am summing the content wich will return #N/A if one cell contains that message. Thanks for any help |
#4
|
|||
|
|||
Try:
=IF(ISNA(VLOOKUP(D3,$H$2:$I$17,2,FALSE)),0,VLOOKUP (D3,$H$2:$I$17,2,FALSE)*C3) Regards Trevor "Jon1205" wrote in message ... I have this equation in the column E cells: =IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)0,VLOOKUP(D3,$H $2:$I$17,2,FALSE)*C3,0) What I am trying to do is if there is no data in column D cells, I want it to enter a zero (0). It is currently returning the #N/A error, wich is the same error if I only had the vlookup () equation. I want it to return a zero (0) because at the bottom I am summing the content wich will return #N/A if one cell contains that message. Thanks for any help |
#5
|
|||
|
|||
I think what you want is:
=IF(ISERROR(VLOOKUP(D3,$H$2:$I$17,2,FALSE)),0,VLOO KUP(D3,$H$2:$I$17,2,FALSE)*C3) "Jon1205" wrote: I have this equation in the column E cells: =IF(VLOOKUP(D3,$H$2:$I$17,2,FALSE)0,VLOOKUP(D3,$H $2:$I$17,2,FALSE)*C3,0) What I am trying to do is if there is no data in column D cells, I want it to enter a zero (0). It is currently returning the #N/A error, wich is the same error if I only had the vlookup () equation. I want it to return a zero (0) because at the bottom I am summing the content wich will return #N/A if one cell contains that message. Thanks for any help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i create a conditional sum? | Excel Worksheet Functions | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |