happyman123uk
Board Regular
- Joined
- Mar 19, 2012
- Messages
- 69
I have a spread sheet which I am working on and want to be able to say if a certain letter is entered into a cell it returns a certain value
W=3 points
D=1 point
L=0 points
so if
a1=W
a2=L
a3=W
a4=D
a5=W
a6=L
a7=W
a8=W
a9 would contain the answer which should be 16
W=3 points
D=1 point
L=0 points
so if
a1=W
a2=L
a3=W
a4=D
a5=W
a6=L
a7=W
a8=W
a9 would contain the answer which should be 16