Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a blank value or zero instead of a #VALUE! error.
I have automated a sheet to populate the value of a specific item using the
IF, VLOOKUP formulas. Everything is great, but at the very end I am getting an error in the last field - F13 is empty until i enter a number (quantity) - in G13 I have the following which auto pulls up a price for a # entered in a previous cell =IF(D13="","",VLOOKUP($E13,$E69:$F$144,COLUMN(B51) ,0)) - in H13 I have the following, =F13*G13 If F13 and G13 are blank, I get the "#VALUE1" error. I need that to be blank or zero, but can't figure out how. Please help! Column | F13 | G13 | H13 | Formula | | (=IF(D13..etc.) | (=F13*G13) | Excel Shows | | | #VALUE! | |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
is blank AND is error | Excel Worksheet Functions | |||
replace error with blank | Excel Worksheet Functions | |||
blank error | Excel Worksheet Functions | |||
error when blank - please help | Excel Discussion (Misc queries) | |||
#DIV/0! Error - Need to display 0 or blank | Excel Worksheet Functions |