| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement help
I need an IF statement that will turn the N/A to 0
Here is my Vlookup formula: =VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE) Thanks for the help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement help
=IF(ISNA(VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE)),0, VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE))
"Confusicous" wrote: I need an IF statement that will turn the N/A to 0 Here is my Vlookup formula: =VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE) Thanks for the help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement help
If you have Excel 2007
=IFERROR(VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE),0) -- __________________________________ HTH Bob "Confusicous" wrote in message ... I need an IF statement that will turn the N/A to 0 Here is my Vlookup formula: =VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE) Thanks for the help! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement help
Thanks for the help. I appreciate it.
"Bob Phillips" wrote: If you have Excel 2007 =IFERROR(VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE),0) -- __________________________________ HTH Bob "Confusicous" wrote in message ... I need an IF statement that will turn the N/A to 0 Here is my Vlookup formula: =VLOOKUP($A4,'P40'!$A$2:$H$83,7,FALSE) Thanks for the help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| If statement or lookup statement not sure | Excel Worksheet Functions | |||
| SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Help please, IF statement/SUMIF statement | Excel Worksheet Functions | |||
Linear Mode
