break it down and then put it together


if(r2="w",if(q2=0,q2,100),if(r2="l",(if(q20,-100,q2)))
or another way
if(q20,if(r2="w"
--
Don Guillett
SalesAid Software

"Jambruins" wrote in message
...
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.