Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with multiple If statement
In cell B4 I have a validation dropdown list of 4 titles. Title 1, 2, 3, 4.
In cell G-4 I would like a dollar amount to be placed in that cell in reference to what is selected in B4. When I place =if(B4"Title1"="$110") I can select Title 1 and have that correct dollar amount appear in the G4 cell. Can I write a statement that will give me different dollar amounts for the four different titles? Thank you in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with multiple If statement
=CHOOSE(RIGHT(B4,1),110,300,325,765)
or any other values you like. -- Gary''s Student - gsnu200756 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with multiple If statement
=LOOKUP(B4,{"Title1","Title2","Title3","Title4";11 0,115,120,125})
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mike Busch" wrote in message ... In cell B4 I have a validation dropdown list of 4 titles. Title 1, 2, 3, 4. In cell G-4 I would like a dollar amount to be placed in that cell in reference to what is selected in B4. When I place =if(B4"Title1"="$110") I can select Title 1 and have that correct dollar amount appear in the G4 cell. Can I write a statement that will give me different dollar amounts for the four different titles? Thank you in advance |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with multiple If statement
If your titles are fed to the validation from the worksheet, then put the
values next to the titles. Then in G4 you can enter =VLOOKUP(B4,$C$1:$D$4,2,FALSE) Where C1:C4 would be your titles, and D1:D4 would be the amounts. Also instead of hardcoding the numbers if any of them change you won't have to go through all the different cells you've copied the formula to, you only need to change the table. "Mike Busch" wrote: In cell B4 I have a validation dropdown list of 4 titles. Title 1, 2, 3, 4. In cell G-4 I would like a dollar amount to be placed in that cell in reference to what is selected in B4. When I place =if(B4"Title1"="$110") I can select Title 1 and have that correct dollar amount appear in the G4 cell. Can I write a statement that will give me different dollar amounts for the four different titles? Thank you in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple IF Statement | Excel Worksheet Functions | |||
IF statement with multiple scenarios. | Excel Discussion (Misc queries) | |||
Multiple If Statement | Excel Worksheet Functions | |||
Help with a multiple OR statement. | Excel Discussion (Misc queries) | |||
IF Statement with multiple conditions | Excel Discussion (Misc queries) |