Error function

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Good morning,

I'm using the following in cell E7--

E7
IF(LEFT(F7,1)="9","SALES GRP","OLD BRANCH")

F7
IF(F4="",INDEX(Sheet1!$A$1:$A$42,MATCH(Sheet2!F3,Sheet1!
$B$1:$B$42,0),1),INDEX(Sheet1!$B$1:$B$42,MATCH(Sheet2!
F4,Sheet1!$A$1:$A$42,0),1))

However if "F7" is blank (#N/A) cell E7 defaults to #N/A,
Can I use the error function to have E7 default to "SALS
GRP" and not #N/A?

Any help is apreciated

Aaron
 
Nope, Same results.... E7 defaults to #N/A
-----Original Message-----
Hi
try in E7:
IF(F7="","SALES GRP",IF(LEFT(F7,1)="9","SALES GRP","OLD BRANCH"))


--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Hi
so F7 is not BLANK but contains an error. in this case try
IF(ISNA(F7),"SALES GRP",IF(LEFT(F7,1)="9","SALES GRP","OLD BRANCH"))
or
IF(ISERROR(F7),"SALES GRP",IF(LEFT(F7,1)="9","SALES GRP","OLD BRANCH"))
 
=IF(ISNA(F7),"SALES GRP",IF(LEFT(F7,1)="9","SALES
GRP","OLD BRANCH"))

HTH
Jason
Atlatna, GA
 
Back
Top