formulas

[Amy Maestas]

I want to be able to enter "D" and have it equal to 6, and "E" equal to 8.75
in the same cell. For example. I enter "D" and it converts the letter into
6 so it can be multiplied by another cell.

 

[BenjieLop]

I want to be able to enter "D" and have it equal to 6, and "E" equal t
8.75
in the same cell. For example. I enter "D" and it converts the lette
into
6 so it can be multiplied by another cell.

Assuming that you will enter "D" or "E" in Cell A1 and the other cel
involved in the multiplication is B1, then you can enter this formul
in Cell C1

=B1*if(A1="D",6,if(A1="E",8.75,1))

BTW, the last number "1" simply means that if Cell A1 is neither "D
nor "E" then Cell C1 will simply be equal to B1. You can always chang
this last argument to suit your requirements.

Hope this is the formula that you are looking for