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

Back	Odds	W/L	Formula	Result
15.00	2.5	W	=IF(C1,"W",A1*B1	37.50

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....

Back	Odds	W/L	Formula	Result
15.00	2.5	L	??	-15.00

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