Excel formula Help
Oops..It should be somthing like the below to assign the weightage..
=C1*(SEARCH(E1,"DCBA")-1)
OR
=C1*(68-CODE(UPPER(E1)))
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
Try the below formula in D1 and copy down as required
=C1*IF(E1="A",3,IF(E1="B",2))
--
If this post helps click Yes
---------------
Jacob Skaria
"MTHowse" wrote:
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
|