Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Thanks Biff one of these days I hope to become an Excel Guru!
-- Thanks, Mike "T. Valko" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Me too!
You're welcome! -- Biff Microsoft Excel MVP "MTHowse" wrote in message ... Thanks Biff one of these days I hope to become an Excel Guru! -- Thanks, Mike "T. Valko" wrote: 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
=C1*(68-CODE(E1))
If OP use a lower case letter your formula returns incorrect value. Try this BULLET proof formula: =C1*(68-CODE(UPPER(E1))) "Rick Rothstein" wrote: 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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Would you believe... I was assuming the letters came from a Data Validation
List? Oh, okay, I wouldn't either.<g Thanks for picking up on that. -- Rick (MVP - Excel) "Teethless mama" wrote in message ... =C1*(68-CODE(E1)) If OP use a lower case letter your formula returns incorrect value. Try this BULLET proof formula: =C1*(68-CODE(UPPER(E1))) "Rick Rothstein" wrote: 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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Then there is always this...
=C1*(4-SEARCH(E1,"ABCD")) -- Rick (MVP - Excel) "Teethless mama" wrote in message ... =C1*(68-CODE(E1)) If OP use a lower case letter your formula returns incorrect value. Try this BULLET proof formula: =C1*(68-CODE(UPPER(E1))) "Rick Rothstein" wrote: 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 |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Yeah, Teethless mama just called me on that one.
-- Rick (MVP - Excel) "T. Valko" wrote in message ... =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 |
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Try this BULLET proof formula:
Not even close to being "bullet proof". And yes, I know, neither is my suggestion. -- Biff Microsoft Excel MVP "Teethless mama" wrote in message ... =C1*(68-CODE(E1)) If OP use a lower case letter your formula returns incorrect value. Try this BULLET proof formula: =C1*(68-CODE(UPPER(E1))) "Rick Rothstein" wrote: 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 |
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Or, depending on personal preferences, this...
=C7*(SEARCH(E7,"DCBA")-1) -- Rick (MVP - Excel) "Rick Rothstein" wrote in message ... Then there is always this... =C1*(4-SEARCH(E1,"ABCD")) -- Rick (MVP - Excel) "Teethless mama" wrote in message ... =C1*(68-CODE(E1)) If OP use a lower case letter your formula returns incorrect value. Try this BULLET proof formula: =C1*(68-CODE(UPPER(E1))) "Rick Rothstein" wrote: 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 |
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Are you SD using an alias?
-- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... 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 |
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel formula Help
Sorry, I didnt get you Biff.
If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: Are you SD using an alias? -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
i edit a formula (excel) then it displays formula not answer | Excel Discussion (Misc queries) |