Posted to microsoft.public.excel.misc

Loving

external usenet poster

Posts: 1

If function question in conditional formula

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<3 5001,$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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formula Question	iperlovsky	Excel Worksheet Functions	1	March 12th 07 03:31 AM
Conditional formatting formula question	Simon	Excel Discussion (Misc queries)	1	July 10th 06 01:23 PM
Conditional Formula question	Renee	Excel Discussion (Misc queries)	3	April 13th 06 08:05 PM
Formula/Function Question	JD01904	Excel Discussion (Misc queries)	2	November 25th 05 03:01 AM
formula/function question	wnl2007	Excel Worksheet Functions	4	June 13th 05 05:51 PM

All times are GMT +1. The time now is 12:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us