Sawyer1206
New Member
- Joined
- Feb 14, 2019
- Messages
- 8
Brand new to the forum and fairly new to Excel and my question is:
Can I format a cell so when I place a letter it will represent a numerical value in a formula?
Here's the scenario: I want to format a cell so when I type in the letter 'E' a multiplier of '1' is placed in a formula but the letter' 'E' is displayed in the cell. I would need to do the same for 'C' which would represent '.01' in a formula and again with 'M' which would represent .001.
Can this be Done?
<tbody>
</tbody>
Can I format a cell so when I place a letter it will represent a numerical value in a formula?
Here's the scenario: I want to format a cell so when I type in the letter 'E' a multiplier of '1' is placed in a formula but the letter' 'E' is displayed in the cell. I would need to do the same for 'C' which would represent '.01' in a formula and again with 'M' which would represent .001.
Can this be Done?
MATERIAL | QUANTITY | PRICE | PER | EXTENSION | LABOR | PER | EXTENSION |
Example per 1 | 1 | 1.00 | E | 1.00 | 8.0 | E | 8.0 |
Example per 100 | 1 | 1.00 | C | 0.01 | 8.0 | C | 0.08 |
example per 1000 | 1 | 1.00 | M | 0.001 | 8.0 | M | 0.008 |
<tbody>
</tbody>