| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to check for 1 of 4 conditions...Help Please
I have created a drop list that has four possible selections (Validation)
being A B C or D in the column next to it I want to do a check and a calculation but I'm having problems with too many "If" scenarios <. How can I get this to check the first column for either A, B ,C or D without my "IF's" conflicting... Ex: If cell A2 = A, then A-100 (goes in cell B2) If cell A2 = B, then B+100 (goes in cell B2) If cell A2 = C, then C/100 (goes in cell B2) If cell A2 = D, then D*100 (goes in cell B2) Thank you -- jgbadingerjr |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) | |||
| Function to check list for specific conditions and return an answe | Excel Discussion (Misc queries) | |||
| How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions | |||
| How do I check the conditions of 2 fields to return a result | Excel Discussion (Misc queries) | |||
Threaded Mode
