View Single Post
  #1   Report Post  
Jennifer Briles Jennifer Briles is offline
Junior Member
 
Posts: 1
Default If, And & Or In Same Formula

Need help in figuring out formula.
Cell 1 is a drop down between a choice of 2 regions (A or B)
Cell 2 is another drop down between a choice of 2 term lengths (3 or 6)
L8=$2200.00; L9=$2500.00; L10=$2000.00; L11=$2100.00

If Cell 1 is A, and Cell 2 is 3, then L8 ......If Cell 1 is A, and Cell 2 is 6, then L10......if Cell 1 is B, and Cell 2 is 3, then L9......if Cell 1 is B, and Cell 2 is 6, then L11

How do Iwrite this formula for this 1 cell?