Multiple results from multiple criteria using IF function

[David Platt]

Any help with this would be extremely helpful as this is driving me mad! I
produce weekly statistics on individual/team performance that are extracted
via SQL but need to attribute a value to show the team that each person works
in. This is currently a manual process and I am trying to automate this to
speed things up. This is using Excel 2000.

What I have is a range of cells with more than one individual name (X,Y and
Z) and need to write a formula that defines what the next cell should be
populated with (Team 1, Team 2 or Team 3 etc). The formula would therefore
want to say that if A1 is X or Y or Z then A2 should be populated with the
name Team 1 or Team 2 or Team 3 (having attributed the name of the Team to
the respective individual within the formula).

I hope that I have explained this ok but please respond if you want to
clarify anything.

Cheers

David

 

[Bob Phillips]

Probably mis-understanding, but

=IF(A1="X","Team1",IF(A1="Y",Team2",IF(A1="Z","Team3,")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)