Can a Letter Represent a Value?

[Sawyer1206]

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?

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>

 

[etaf]

are you trying to roundup?

so 12.49 would be 12 and 12.5 would be 13 - or all should be 13
use roundup()