| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional/Nested Formula
I have a drop down list in B3 with three (text) values - call then a, b, and,
c. Based on what a user selects in the drop down, I need to perform other calculations: If B3 = "a", I want to populate E3 with 0, or If B3 = "b", I want to populate E3 with 1, or If B3 = "c", I want to populate E3 with 2 I'm at a loss... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested Formula help | Excel Discussion (Misc queries) | |||
| Iserror nested within a conditional vlookup | Excel Worksheet Functions | |||
| CONDITIONAL / NESTED COUNTIF | Excel Worksheet Functions | |||
| Nested ifs and conditional population | Excel Worksheet Functions | |||
| Nested functions in conditional formatting formulae | Excel Discussion (Misc queries) | |||
Threaded Mode
