| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculation based on lists selected
Hi,
I have validated a cell(Data Validation) where the validation criteria allows a list and the source is 2 cells containing Y, N. Now, depending on the list selected, a formula should be calculated. ie. if Y, (B1+B2)-(A1+A2) if N, (C1+C2)-(A1+A2) I have tried a lot but in vain. Pls help out. Sups --- Message posted from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep the drop down arrow on data lists when not selected? | Excel Worksheet Functions | |||
| Highlight the cell based on selected value | Excel Worksheet Functions | |||
| Returning value in secocolumn based on selected value in first col | Excel Worksheet Functions | |||
| Perform a calculation based on a cell being selected | Excel Worksheet Functions | |||
| How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
Threaded Mode
