Something like:

=If(And(b2=33,c2=18),"calc profit","else do ??")

=If(And(b2=33,c2=9),"calc profit","else do ??")

Copy these down the required columns.


"Jspearm" wrote:

In tracking performance of different tournaments, I want to know my results
based on the buyin and number of players in the tournament. I have more info
in the rows, but I only want to know my profit if there were 18 players, and
the buyin was 33. And in another cell, the profit if Buyin was 33 with 9
players, and so on. (there are more buyins and numbers but this will be
easier)

B2=33
B3=33
B4=33
C2=18
C3=18
C4=9

Any help would be greatly appriciated. Im using office 2003