If function question in conditional formula

[Guest]

I need help with creating a formula that will find a name in colums A & B, if
true or false a % is returned when comparing a value in another column.

The following formula only works when the name is found in both columns A&B.
I need to check if the name is found in either column A or B:

IF((A9=$A$64)*(B9=$A$64),(IF(N9<25001,$A$3,IF(N9<35001,$A$4,IF(N9<45001,$A$5,IF(N9<55001,$A$6))))),(IF(N9<35001,$A$4,IF(N9<45001,$A$5,IF(N9<55001,$A$6)))))

Your help is very much appreciated. I'm using Microsoft Excel 2003

 

[Earl Kiosterud]

Loving,

Change the first part to:

=IF((A9=$A$14)+(B9=$A$14)...

I got dizzy trying to figure out the rest, but I think this is the part you're asking about.
--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[T. Valko]

Try this:

=IF(OR(A9=$A$64,B9=$A$64),LOOKUP(N9,{0;25001;35001;45001},$A$3:$A$6),LOOKUP(N9,{35001;45001;55001},$A$4:$A$6))

Biff