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?
|