Originally Posted by Claus Busch

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