| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Making N/A become a zero
If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result
to show as a zero (0) instead? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making N/A become a zero
=IF(ISNA("your vlookup here"),0,"your vlookup here")
or =IF(ISERROR("your vlookup here"),0,"your vlookup here") -- Carlos "Jaye" wrote in message ... If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result to show as a zero (0) instead? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making N/A become a zero
You can wrap your VLOOKUP formula in an IF statement, like.....
=IF(ISNA(YourVlookupFormula),0,YourVlookupFormula) Vaya con Dios, Chuck, CABGx3 "Jaye" wrote: If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result to show as a zero (0) instead? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making N/A become a zero
Hi!
Try this: =IF(ISNA(your_vlookup_here)),0,your_vlookup_here)) Biff "Jaye" wrote in message ... If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result to show as a zero (0) instead? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Making N/A become a zero
Hi, Chuck!! Thanks for your help. Worked perfectly.
"CLR" wrote: You can wrap your VLOOKUP formula in an IF statement, like..... =IF(ISNA(YourVlookupFormula),0,YourVlookupFormula) Vaya con Dios, Chuck, CABGx3 "Jaye" wrote: If I do a VLOOKUP and the resulting answer is #N/A, how can I get the result to show as a zero (0) instead? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making multiple cells absolute at once | Excel Discussion (Misc queries) | |||
| extracting comments in a cell and making these part of the Chart . | Charts and Charting in Excel | |||
| Making Mailing Labels | Links and Linking in Excel | |||
| making an employee schedule in two sheets | Excel Worksheet Functions | |||
| making a workbook into a web page. | Excel Worksheet Functions | |||
Linear Mode
