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?

[TABLE="width: 1000"]
<tbody>[TR]
[TD]MATERIAL[/TD]
[TD]QUANTITY[/TD]
[TD]PRICE[/TD]
[TD]PER[/TD]
[TD]EXTENSION[/TD]
[TD]LABOR[/TD]
[TD]PER[/TD]
[TD]EXTENSION[/TD]
[/TR]
[TR]
[TD]Example per 1[/TD]
[TD]1
[/TD]
[TD]1.00
[/TD]
[TD]E[/TD]
[TD]1.00[/TD]
[TD]8.0[/TD]
[TD]E[/TD]
[TD]8.0[/TD]
[/TR]
[TR]
[TD]Example per 100[/TD]
[TD]1
[/TD]
[TD]1.00[/TD]
[TD]C[/TD]
[TD]0.01[/TD]
[TD]8.0[/TD]
[TD]C[/TD]
[TD]0.08[/TD]
[/TR]
[TR]
[TD]example per 1000[/TD]
[TD]1[/TD]
[TD]1.00[/TD]
[TD]M[/TD]
[TD]0.001[/TD]
[TD]8.0[/TD]
[TD]M[/TD]
[TD]0.008[/TD]
[/TR]
</tbody>[/TABLE]

 

[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()