| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
logical test for an #N/A condition in a cell
I have a VLOOKUP that returns a dollar value from another spreadsheet. If an
entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
logical test for an #N/A condition in a cell
To test for #N/A, you can use "ISNA":
=IF(ISNA(VLOOKUP(A1,Sheet2!B1:C20,2,0)),0,VLOOKUP( A1,Sheet2!B1:C20,2,0)) Laura "F.Rosario" wrote in message ... I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
logical test for an #N/A condition in a cell
Thank you very much!
"Laura Cook" wrote: To test for #N/A, you can use "ISNA": =IF(ISNA(VLOOKUP(A1,Sheet2!B1:C20,2,0)),0,VLOOKUP( A1,Sheet2!B1:C20,2,0)) Laura "F.Rosario" wrote in message ... I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
logical test for an #N/A condition in a cell
-IF(ISNA(YOURVLOOKUPFORMULA),0,YOURVLOOKUPFORMULA)
Vaya con Dios, Chuck, CABGx3 "F.Rosario" wrote: I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
logical test for an #N/A condition in a cell
Thank you very much, that solved my problem!
"CLR" wrote: -IF(ISNA(YOURVLOOKUPFORMULA),0,YOURVLOOKUPFORMULA) Vaya con Dios, Chuck, CABGx3 "F.Rosario" wrote: I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
logical test for an #N/A condition in a cell
This works for #N/A as well as other orrors:
=IF(ISERROR(A1),0,A1) -- Gary''s Student - gsnu200761 "F.Rosario" wrote: I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
logical test for an #N/A condition in a cell
Thank you very much, that solved my problem as well!
"Gary''s Student" wrote: This works for #N/A as well as other orrors: =IF(ISERROR(A1),0,A1) -- Gary''s Student - gsnu200761 "F.Rosario" wrote: I have a VLOOKUP that returns a dollar value from another spreadsheet. If an entry is not found, the cell value becomes #N/A, which affects the summary of that column. I want to test for the #N/A condition and make it 0, but I haven't figured out the syntax to compare the value of a cell to #N/A. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Logical test if cell uses formatting.. | Excel Worksheet Functions | |||
| IF functionality, Logical Test = Nonbalnk Cell | Excel Worksheet Functions | |||
| Logical Test comparison using cell color | Excel Discussion (Misc queries) | |||
| logical test for each and every cell in range | Excel Discussion (Misc queries) | |||
| =IF logical test to search only part of a cell | Excel Worksheet Functions | |||
Hybrid Mode
