Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If function with lots of criteria
Hi All,
I want to create a formula that changes the content of a cell, based on what information is in the other cells. For example: If A1= "Team A" and B1 is between 10 and 1000, then C1 = Action or if A1 = "Team A" and B1 is greater than 1000, then C1 = Report or If A1 = "Team B" and B1 is between 100 and 10,000, then C1 = Action or If A1 = "Team B" and B1 is greater 10,000, then C1 = Report or If A1 = "Team C" then C1 = Report Any help would be greatly appreciated !! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function with lots of criteria
Hi,
Am Thu, 18 Sep 2014 09:10:53 +0100 schrieb Jooniper: For example: If A1= "Team A" and B1 is between 10 and 1000, then C1 = Action or if A1 = "Team A" and B1 is greater than 1000, then C1 = Report or If A1 = "Team B" and B1 is between 100 and 10,000, then C1 = Action or If A1 = "Team B" and B1 is greater 10,000, then C1 = Report or If A1 = "Team C" then C1 = Report try: =IF(OR(AND(A1="Team A",B1=10,B1<=1000),AND(A1="Team B",B1=100,B1<=10000)),"Action",IF(OR(AND(A1="T eam A",B11000),AND(A1="Team B",B110000),A1="Team C"),"Report","")) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#3
|
|||
|
|||
Thank you very much Claus. I now need help with the below:
If A1= "Team A" and B1 is between 10 and 1000, then D1 = 10 or if A1 = "Team A" and B1 is greater than 1000, then D1 = 1000 or If A1 = "Team B" and B1 is between 100 and 10,000, then D1 = 100 or If A1 = "Team B" and B1 is greater 10,000, then D1 = 10000 or If A1 = "Team C" then C1 = Report[/i][/color] Quote:
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function with lots of criteria
Hi,
Am Thu, 18 Sep 2014 11:25:10 +0100 schrieb Jooniper: If A1= "Team A" and B1 is between 10 and 1000, then D1 = 10 or if A1 = "Team A" and B1 is greater than 1000, then D1 = 1000 or If A1 = "Team B" and B1 is between 100 and 10,000, then D1 = 100 or If A1 = "Team B" and B1 is greater 10,000, then D1 = 10000 or If A1 = "Team C" then C1 = Report[/i][/color] try: =IF(AND(A1="Team A",B1=10,B1<=1000),10,IF(AND(A1="Team A",B11000),1000,IF(AND(A1="Team B",B1=100,B1<=10000),100,IF(AND(A1="Team B",B110000),10000,IF(A1="Team C","Report",""))))) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#5
|
|||
|
|||
This is absolutely fantastic. Thank you so much again
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with lots of formulas | Excel Worksheet Functions | |||
Need help with sort function and lots of data? | Excel Discussion (Misc queries) | |||
How to sum lots of columns(over 200) with one criteria? | Excel Discussion (Misc queries) | |||
Lots of Frustration - Lots of Arrays, Dynamic Ranges Don't Work, Help With Options | Excel Programming | |||
Comining lots of functions into one User defined function | Excel Programming |