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 |
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) |