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:
Originally Posted by Claus Busch
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
|