Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
I have a vlookup in one column that has results = #N/A
I need to do an if statement, that looks like: If the field =#N/A, then 0, if not, the field. Basically, I want to convert all of the #N/A's to a 0 (zero) in another column.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
You could copy and paste the results as values, then highlight the column and
'edit ' , 'replace' , find what = #N/A , replace with = 0 "Send Object Command - Two attachments" wrote: I have a vlookup in one column that has results = #N/A I need to do an if statement, that looks like: If the field =#N/A, then 0, if not, the field. Basically, I want to convert all of the #N/A's to a 0 (zero) in another column.... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
I know I can that....however, I need to have this in a formula.
I need this done automatically. Any other suggestions? Thanks - "PhilinLondon" wrote: You could copy and paste the results as values, then highlight the column and 'edit ' , 'replace' , find what = #N/A , replace with = 0 "Send Object Command - Two attachments" wrote: I have a vlookup in one column that has results = #N/A I need to do an if statement, that looks like: If the field =#N/A, then 0, if not, the field. Basically, I want to convert all of the #N/A's to a 0 (zero) in another column.... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
=IF(ISNA(VLOOKUP([your vlookup]),0,VLOOKUP([your vlookup]))
Dave -- Brevity is the soul of wit. "Send Object Command - Two attachments" wrote: I know I can that....however, I need to have this in a formula. I need this done automatically. Any other suggestions? Thanks - "PhilinLondon" wrote: You could copy and paste the results as values, then highlight the column and 'edit ' , 'replace' , find what = #N/A , replace with = 0 "Send Object Command - Two attachments" wrote: I have a vlookup in one column that has results = #N/A I need to do an if statement, that looks like: If the field =#N/A, then 0, if not, the field. Basically, I want to convert all of the #N/A's to a 0 (zero) in another column.... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
=IF(ISNA(formula),0,formula)
replace formula with your formula, or the cell in question. you can also use the following formula to account for any other type of error (#DIV/0 for example). =IF(ISERROR(formula),0,formula) "Send Object Command - Two attachments" wrote: I have a vlookup in one column that has results = #N/A I need to do an if statement, that looks like: If the field =#N/A, then 0, if not, the field. Basically, I want to convert all of the #N/A's to a 0 (zero) in another column.... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
I have ssumed that you have a formula that either gives a value or #N/A To do what you want you need to refer to the error, not the result =IF(ISERROR(cell ref),0,1) If the cell you are pointing to results in an error (eg #N/A) then it will give a value of 0, if no error found then it will give a value of 1 Hope this helps Steve |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid If statement question....
Worked like a charm - thansk to all.
"Sloth" wrote: =IF(ISNA(formula),0,formula) replace formula with your formula, or the cell in question. you can also use the following formula to account for any other type of error (#DIV/0 for example). =IF(ISERROR(formula),0,formula) "Send Object Command - Two attachments" wrote: I have a vlookup in one column that has results = #N/A I need to do an if statement, that looks like: If the field =#N/A, then 0, if not, the field. Basically, I want to convert all of the #N/A's to a 0 (zero) in another column.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stupid List Box Question | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement question | Excel Worksheet Functions | |||
If Statement Question | Excel Worksheet Functions |