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 !!

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

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]

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

This is absolutely fantastic. Thank you so much again