Excel formula Help
=C1*(68-CODE(E1))
Just to be on the safe side I'd use this:
=C1*(68-CODE(UPPER(E1)))
--
Biff
Microsoft Excel MVP
"Rick Rothstein" wrote in message
...
Here is a little bit shorter formula to do the same thing...
=C1*(68-CODE(E1))
--
Rick (MVP - Excel)
"T. Valko" wrote in message
...
If your scale is:
A= 3
B = 2
C = 1
D = 0
=C1*(MATCH(E1,{"D","C","B","A"},0)-1)
--
Biff
Microsoft Excel MVP
"MTHowse" wrote in message
...
I know this is simple but I do not know how to make it work.
Column A, B and C contain numbers, Column E contains letters A, B, C, D.
What I want to do is if Column E contains A then Column D=C*3 if Column
E
contains B then Column D=C*2, etc.
--
Thanks,
Mike
|