Hi,
I need to to assign a fixed value to "CLUB MEMBER" another different fixed number to "CLUB STATION" and yet another given value for the text "NO CLUB". These numbers would appear in another cell.
i.e Text CLUB MEMBER puts 50 in another cell. I can then add all of these for a final score. I am using Excel 2003.I am no VB programmer but I will give it a go. Any help would be appreciated
Cheers,
Frederick
you could put the labels (eg club member) in the left most column of cells and then put your vales you the right. Like this: col A | col B
club member | 50Then you just sum them. In excel you click on the cell you want the total to appear in and type "=sum(B1:B3)" (no quotation marks) this assumes that your values are in cells B1, B2, and B3. You could also put "=B1+B2+B3" (no quotation marks).
Can't get the voting thingy to work. Thank you for this, very helpful. I appreciate the effort. Regards
If you have data like this, then an IF statement should work for you: A 1 CLUB MEMBER 2 CLUB MEMBER 3 CLUB STATION 4 NO CLUB 5 CLUB STATIONPut this in B1 and drag it down.
=IF(A1="CLUB MEMBER",50,IF(A1="CLUB STATION",40,30))
If that is not what you are looking for, please provide some more details.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
Just what I want.......thanks. Can't get the voting thing to work. F