| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF ISERROR
Hi guys, looking for some help ,,,,, I am trying to use the ISERROR function
within a formula to return 0% if the data returned is an error ,,,,,, formula is =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)), which in itself works fine, but can't get the iF ISERROR to work with it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF ISERROR
Nel post
*John Moore* ha scritto: Hi guys, looking for some help ,,,,, I am trying to use the ISERROR function within a formula to return 0% if the data returned is an error ,,,,,, formula is =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)), which in itself works fine, but can't get the iF ISERROR to work with it. Hi John, I think you don't need ISERROR, you could use the second condition of IF: =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0),0) I make the assumption the cell in which the formula is written has been formatted as percentage, so you don't need to put inside the formula. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF ISERROR
If any of the lookups could fail, you could try
=IF($A$3="4Q05",IF(ISERROR(VLOOKUP($C11,fourth,2,0 )/VLOOKUP($C11,fourth,4,0) ),"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") If it is just that the division might result in 0, then use =IF($A$3="4Q05",IF(VLOOKUP($C11,fourth,4,0)=0,"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "John Moore" wrote in message ... Hi guys, looking for some help ,,,,, I am trying to use the ISERROR function within a formula to return 0% if the data returned is an error ,,,,,, formula is =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)), which in itself works fine, but can't get the iF ISERROR to work with it. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF ISERROR
Hi Bob, your formula works fine ,,, thanks for that ,,,,one question though
,,,, what if I wnat to extend it to cover multpile IF's .... such as =IF($A$3="4Q05",VLOOKUP($C11,fourth,3,0)/VLOOKUP($C11,fourth,14,0),IF($A$3="1Q06",VLOOKUP($ C11,first,3,0)/VLOOKUP($C11,first,14,0),IF($A$3="2Q06",VLOOKUP($C 11,second,3,0)/VLOOKUP($C11,second,14,0)))) Can the IF ISERROR still be used ?? "Bob Phillips" wrote: If any of the lookups could fail, you could try =IF($A$3="4Q05",IF(ISERROR(VLOOKUP($C11,fourth,2,0 )/VLOOKUP($C11,fourth,4,0) ),"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") If it is just that the division might result in 0, then use =IF($A$3="4Q05",IF(VLOOKUP($C11,fourth,4,0)=0,"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "John Moore" wrote in message ... Hi guys, looking for some help ,,,,, I am trying to use the ISERROR function within a formula to return 0% if the data returned is an error ,,,,,, formula is =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)), which in itself works fine, but can't get the iF ISERROR to work with it. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF ISERROR
Like so?
=IF($A$3="4Q05",IF(ISERROR(VLOOKUP($C11,fourth,3,0 )/VLOOKUP($C11,fourth,14,0 )),"",VLOOKUP($C11,fourth,3,0)/VLOOKUP($C11,fourth,14,0)), IF($A$3="1Q06",IF(ISERROR(VLOOKUP($C11,first,3,0)/VLOOKUP($C11,first,14,0)), "",VLOOKUP($C11,first,3,0)/VLOOKUP($C11,first,14,0)), IF($A$3="2Q06",IF(ISERROR(VLOOKUP($C11,second,3,0)/VLOOKUP($C11,second,14,0) ),"",VLOOKUP($C11,second,3,0)/VLOOKUP($C11,second,14,0)),""))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "John Moore" wrote in message ... Hi Bob, your formula works fine ,,, thanks for that ,,,,one question though ,,,, what if I wnat to extend it to cover multpile IF's .... such as =IF($A$3="4Q05",VLOOKUP($C11,fourth,3,0)/VLOOKUP($C11,fourth,14,0),IF($A$3=" 1Q06",VLOOKUP($C11,first,3,0)/VLOOKUP($C11,first,14,0),IF($A$3="2Q06",VLOOKU P($C11,second,3,0)/VLOOKUP($C11,second,14,0)))) Can the IF ISERROR still be used ?? "Bob Phillips" wrote: If any of the lookups could fail, you could try =IF($A$3="4Q05",IF(ISERROR(VLOOKUP($C11,fourth,2,0 )/VLOOKUP($C11,fourth,4,0) ),"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") If it is just that the division might result in 0, then use =IF($A$3="4Q05",IF(VLOOKUP($C11,fourth,4,0)=0,"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "John Moore" wrote in message ... Hi guys, looking for some help ,,,,, I am trying to use the ISERROR function within a formula to return 0% if the data returned is an error ,,,,,, formula is =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)), which in itself works fine, but can't get the iF ISERROR to work with it. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF ISERROR
Hi Bob ,,, works a treat, thanks again.
"Bob Phillips" wrote: Like so? =IF($A$3="4Q05",IF(ISERROR(VLOOKUP($C11,fourth,3,0 )/VLOOKUP($C11,fourth,14,0 )),"",VLOOKUP($C11,fourth,3,0)/VLOOKUP($C11,fourth,14,0)), IF($A$3="1Q06",IF(ISERROR(VLOOKUP($C11,first,3,0)/VLOOKUP($C11,first,14,0)), "",VLOOKUP($C11,first,3,0)/VLOOKUP($C11,first,14,0)), IF($A$3="2Q06",IF(ISERROR(VLOOKUP($C11,second,3,0)/VLOOKUP($C11,second,14,0) ),"",VLOOKUP($C11,second,3,0)/VLOOKUP($C11,second,14,0)),""))) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "John Moore" wrote in message ... Hi Bob, your formula works fine ,,, thanks for that ,,,,one question though ,,,, what if I wnat to extend it to cover multpile IF's .... such as =IF($A$3="4Q05",VLOOKUP($C11,fourth,3,0)/VLOOKUP($C11,fourth,14,0),IF($A$3=" 1Q06",VLOOKUP($C11,first,3,0)/VLOOKUP($C11,first,14,0),IF($A$3="2Q06",VLOOKU P($C11,second,3,0)/VLOOKUP($C11,second,14,0)))) Can the IF ISERROR still be used ?? "Bob Phillips" wrote: If any of the lookups could fail, you could try =IF($A$3="4Q05",IF(ISERROR(VLOOKUP($C11,fourth,2,0 )/VLOOKUP($C11,fourth,4,0) ),"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") If it is just that the division might result in 0, then use =IF($A$3="4Q05",IF(VLOOKUP($C11,fourth,4,0)=0,"", VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)),"") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "John Moore" wrote in message ... Hi guys, looking for some help ,,,,, I am trying to use the ISERROR function within a formula to return 0% if the data returned is an error ,,,,,, formula is =IF($A$3="4Q05",VLOOKUP($C11,fourth,2,0)/VLOOKUP($C11,fourth,14,0)), which in itself works fine, but can't get the iF ISERROR to work with it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISERROR | Excel Worksheet Functions | |||
| ISERROR Conundrum | Excel Worksheet Functions | |||
| How do I throw in an ISERROR function on a complicated VVLOOKUP? | Excel Discussion (Misc queries) | |||
| Iserror and Vlookup | Excel Worksheet Functions | |||
| ISERROR Functin to Much Work! | Excel Worksheet Functions | |||
Hybrid Mode
