IF formual based on two criteria with a minus figure

[redspanna]

I have simple table below that will work out return and place into E1 if a W is placed into C1

[table="width: 200, class: grid"]
[tr]
[td]Back[/td]
[td]Odds[/td]
[td]W/L[/td]
[td]Formula[/td]
[td]Result[/td]
[/tr]
[tr]
[td]15.00[/td]
[td]2.5[/td]
[td]W[/td]
[td]=IF(C1,"W",A1*B1[/td]
[td]37.50[/td]
[/tr]
[/table]

how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure using the figure shown in A1


example....

[table="width: 200, class: grid"]
[tr]
[td]Back[/td]
[td]Odds[/td]
[td]W/L[/td]
[td]Formula[/td]
[td]Result[/td]
[/tr]
[tr]
[td]15.00[/td]
[td]2.5[/td]
[td]L[/td]
[td]??[/td]
[td]-15.00[/td]
[/tr]
[/table]

hope makes sense and thanks in advance

 

[nskatoch]

Try this
IF(A1*B1>=0,"W","L")

 

[Fluff]

Maybe
=A2*(IF(C2="W",B2,IF(C2="L",-1,0)))

 

[redspanna]

Maybe
=A2*(IF(C2="W",B2,IF(C2="L",-1,0)))

Great, thanks

 

[Fluff]

You're welcome & thanks for the feedback