| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to assign a value to the letter R in a cell range
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i assign a range of numbers to a cell in excel | Excel Discussion (Misc queries) | |||
| How do I assign a letter value to a range of data? | Excel Discussion (Misc queries) | |||
| Can I assign a shortcut key (alt letter) to the format painter | Excel Discussion (Misc queries) | |||
| How do I assign numerical values to a letter? Ex: A = 4, B=3, etc | Excel Worksheet Functions | |||
| How do I assign a numeric value to a text letter | Excel Discussion (Misc queries) | |||
Threaded Mode
