Too Many Arguements

[Zacs]

Hi Guys

This say it has too many arguements, Is there any other way i cna od this to make it work?

=IF(AND(J3="Win",G3="Each Way"),(E3*H3)+(H3*(E3/4)),IF(AND(J3="Win",G3="Win"),(E3*H3),IF(AND(J3="Placed",G3="Win"),0),IF(AND(J3="Placed",G3="Each Way"),(E3/4)*(H3/2)),IF(J3="Lose",0)

cheers

[Fluff13]

Hi & welcome to the board
Maybe
=IF(AND(J3="Win",G3="Each Way"),(E3*H3)+(H3*(E3/4)),IF(AND(J3="Win",G3="Win"),E3*H3,IF(AND(J3="Placed",G3="Win"),0,IF(AND(J3="Placed",G3="Each Way"),(E3/4)*(H3/2),IF(J3="Lose",0,"")))))

[LeoSkywalker]

Seems you've got wrong placement of parenthesese.

Maybe this one:

=IF(AND(J3="Win",G3="Each Way"),(E3*H3)+(H3*(E3/4)),IF(AND(J3="Win",G3="Win"),(E3*H3),IF(AND(J3="Placed",G3="Win"),IF(AND(J3="Placed",G3="Each Way"),(E3/4)*(H3/2)),IF(J3="Lose",0))))

[Fluff13]

Leo
You seem to have missed the 0 on this section
IF(AND(J3="Placed",G3="Win"),0,IF

[LeoSkywalker]

Fluff,

You're right, it's hard to tell sometimes when the formula is somewhat long , and several nested ifs, and the question has no data.