Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |