try
=if(r2="W",if(Q20,Q2,100),if(Q20,-100,Q2))
you may need to play with Q20 to be Q2=0
If R2 can be something other than W or L you may have to add to the equation

"Jambruins" wrote:

I want a formula in cell S2 to do the following...

If R2 = W and Q2 is a positive number display Q2.
If R2 = W and Q2 is a negative number display 100.
If R2 = L and Q2 is a positive number display -100.
IF R2 = L and Q2 is a negative number display Q2.

What formula would I use for this? Thanks.