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