Functions

  • Thread starter Thread starter Wendy
  • Start date Start date
W

Wendy

Is there a way when you do functions that if the function doesn't work, it
doesn't bring back ak value...like you know if ou put FALSE, you will get
#N/A in your cell where the function was..I want it to bring back
nothing.....

=IF(AR39<>"BY
OTHERS",VLOOKUP($BY$31,$BZ$18:$CC$20,IF(OR($AR$19="INTERIOR",$AR$19="20
MIN.(UL 10-B) NEG.PRESSURE", $AR$19="20 MIN.
POS.PRESSURE"),2,IF($AR$19="EXTERIOR",3,IF($AR$19="45 MIN.(UL 10-B)
NEG.PRESSURE",4,4))), FALSE),"")

in the section where it's false, if you put "" it will bring back #VALUE!


thanks

Wendy
 
=if(iserror(vlookup),"",vlookup)

or

=if(countif(A:A,value),vlookup(value,A:F,2,0),"")



hopefully you can apply that approach to your function.
 
use iserror or isna to avoid this.

=IF(ISERROR(IF(AR39<>"BYOTHERS",VLOOKUP($BY$31,$BZ$18:$CC$20,IF(OR($AR$19="I
NTERIOR",$AR$19="20
MIN.(UL 10-B) NEG.PRESSURE", $AR$19="20
MIN.POS.PRESSURE"),2,IF($AR$19="EXTERIOR",3,IF($AR$19="45 MIN.(UL
10-B)NEG.PRESSURE",4,4))),
FALSE),"")),"",IF(AR39<>"BYOTHERS",VLOOKUP($BY$31,$BZ$18:$CC$20,IF(OR($AR$19
="INTERIOR",$AR$19="20
MIN.(UL 10-B) NEG.PRESSURE", $AR$19="20
MIN.POS.PRESSURE"),2,IF($AR$19="EXTERIOR",3,IF($AR$19="45 MIN.(UL
10-B)NEG.PRESSURE",4,4))), FALSE),""))
 
Back
Top