Is there a better way than many If statements ? (Solved)

[m.gold]

What I'm attempting to do is keep track of some gambling bets (no judgment please) and hoping excel can help me easily do that. The main problem I'm having is how to keep track of money won and lost per bet.

If team A is favored by a negative amount (ex -110) that means if team A is selected and they win, I'd win 100. If they lose, I lose 110

If team B is an underdog they have a positive amount (ex +120) so if they are selected and win, id win 120 and if they lose, I'd lose 100

Third option is a push - no money changes hands.


So what I'm doing is listing the team I take (no help needed), the amount wagered (no help needed) and the negative or positive numbers as listed above in the examples (again, I can type this) but in a 4th column when I type W, L or P (win loss or push), I'd like the 5th column to compute my result. Can anyone help with this please?

The scenarios are, IF D1="w" & IF C1>0, then the result is E1=.01*B1*C1
But if D1="w" & C1<0, then the result is E1=B1

If d1="L" & C1>0, then E1=b1*-1
And if D1="L" & C1<0, E1=.01*B1*c1

If d1="p", E1=0


What I don't know how to do is, to have two conditions with an IF statement (if A loses & If A is an underdog), I also don't know of a better formula or function to use. Can anyone please help?
Thanks in advance

[EchoPassenger]

What I don't know how to do is, to have two conditions with an IF statement (if A loses & If A is an underdog), I also don't know of a better formula or function to use.
Thanks in advance

Just wrap your arguments in an AND() function within the logical test part of the IF() function...

IF( AND(A loses , A is an underdog) , VALUE IF TRUE , VALUE IF FALSE )

[m.gold]

Just wrap your arguments in an AND() function within the logical test part of the IF() function...

IF( AND(A loses , A is an underdog) , VALUE IF TRUE , VALUE IF FALSE )

That worked perfectly
Thanks for the help and education