response:formula problem

[gazza uk]

I have made a sheet up for a on line golf club with help from some guys on here (john for 1) but i have one problem left which is

if you look at the week you see there is a score inputted which is then converted to bonus points and total points for that week but i want to be able to enter wd into the week column and get it to show -1 in the score column i have inclosed a sheet for you to see

so if i enter "wd" into cell C6 i want cell E6 to say" -1"

[shg]

Please take a few minutes to reread the forum rules, and then amend your thread title accordingly.

Thanks.