THANKS so much for the Very SPeedy answer!!! It worked like a charm! And
from your answer was able to figure out how I should have done it with the
Insert Function. Thanks again!!! I Love this site!!!

"Max" wrote:

.. In cell C2, if B2= W, C2 should be 2 if B2= L, C2 should be .5

In C2: =IF(B2="W",2,IF(B2="L",0.5,""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---