Chris

In E4 enter

=IF(D4="C",C4*0.01,IF(D4="M",C4*0.001,IF(D4="E",C4 *1,0)))

I think that your decimals were wrong - this give the same result as you
showed

Regards
Peter

"Chris B" wrote:

I have an Time and Material Calculator that I have made. I would
like to be able to asign a number to a letter. Example if I enter "C" into a
column I would like it to represent .001. If I enter "M" into the same
column I would like it to represent .0001, and if I enter "E" it would
represent 1. When I get pricing for my materials they come per 100, 1000
or each. I would like to just enter the pricing, unit of measure and have it
calculate the per item pricing. Example, widgit A cost 80 per 100, I would
like to enter 80 and a C and have it calculate that it cost .80 per widgit.
Right now it looks like this


Quan Item Price Unit Each Cost
2 Widgit 80 C .80 1.60

At this time when I get the updated pricing I have to go
through and change the "price" and "each" column every time I get updated
pricing. I would like to be able to just change the "price " column. I
hope I exlplained this right. Thanks for any help!