View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kuliano Kuliano is offline
external usenet poster
 
Posts: 1
Default 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...