Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Functions
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Functions
=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. -- Regards, Tom Ogilvy "Wendy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |