If Then Else formula

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

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

in excel lingo

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

--
Greetings from New Zealand
Bill K

"hoser" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>
>
> --
> hoser
> ------------------------------------------------------------------------
> hoser's Profile:
> http://www.excelforum.com/member.php...o&userid=24226
> View this thread: http://www.excelforum.com/showthread...hreadid=378414
>

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

Good on you.

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

--
Greetings from New Zealand
Bill K

"hoser" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks for your response, I actually figured it out after some more
> messing around after I did my post.
>
>
> --
> hoser
> ------------------------------------------------------------------------
> hoser's Profile:
> http://www.excelforum.com/member.php...o&userid=24226
> View this thread: http://www.excelforum.com/showthread...hreadid=378414
>