Help with basic If Then Else formula

[hoser]

I am an experience computer user but probably only barely past basic
when it comes to doing formulas and such in programs like excel. I am
trying to create an IF THEN ELSE (I think) formula for a fantasy
football worksheet. Here is the situation. There will be four
winners, 1st, 2nd, 3rd, and 4th place. And there will also be an added
reward for completing the season with the most points. I have it look
something like this.

Playoff Finish Playoff Teams Most Points
Winner P1 x (c1)
2nd P4 (d1)
3rd P6 (e1)
4th P8 (f1)

Total Payout Minus Entry Fee Final Winnings
$90 (d1) $20 $70
$40 (d2) $20 $20
$30 (d3) $20 $10
$20 (d4) $20 $0

Winnings
Superbowl Champ $90 (a12)
2nd Place $40 (a13)
3rd Place $30 (a14)
4th Place $20 (a15)

Most Points $20 (a17)


Under "Most Points" I just want to put an "x" in the cell by the player
that had the most points. In the next column (Total Payout) I want a
formula stating If the preceding cell has a "x" then (refer to winnings
cells) PLUS (most points cell) = Total Payout else (winning cell).
Example. =If c1=x then sum(a12+a17) else a12
I know that this formula does not work, even though it makes sence to
me. Could someone give me some advice?

thanks

 

[Bill Kuunders]

=If c1=x then sum(a12+a17) else a12

in excel lingo

=if(c1="x",a12+a17,a12)

 

[hoser]

Thanks for your response, I actually figured it out after some more
messing around after I did my post.

 

[Bill Kuunders]

Good on you.

keep on messing about and find out all kinds of wonderfull things in excel
not much it can't do.