Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function question in conditional formula
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... ----------------------------------------------------------------------- "Loving" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function question in conditional formula
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 "Loving" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula Question | Excel Worksheet Functions | |||
Conditional formatting formula question | Excel Discussion (Misc queries) | |||
Conditional Formula question | Excel Discussion (Misc queries) | |||
Formula/Function Question | Excel Discussion (Misc queries) | |||
formula/function question | Excel Worksheet Functions |