G
Guest
Actually it's not as simple as what's written in the subject line. I want to
have the following happen; If I enter the letter "r" in a specified cell
range then I want a numeric value of 8 to appear in the total column cell
range for that line. However if I enter "R+1" then it should read as 9 "R+2"
10 etc... here's an example of what I'm trying to acheive,
Name Mon Tues Wed.... Total
Bob Doug R+2 R-1 R 25
Tom David R-5 R+3 R+1 23
Any suggestions?
have the following happen; If I enter the letter "r" in a specified cell
range then I want a numeric value of 8 to appear in the total column cell
range for that line. However if I enter "R+1" then it should read as 9 "R+2"
10 etc... here's an example of what I'm trying to acheive,
Name Mon Tues Wed.... Total
Bob Doug R+2 R-1 R 25
Tom David R-5 R+3 R+1 23
Any suggestions?