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