Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula autofill to cells below – formula arguments are cell areas in different columns | Excel Discussion (Misc queries) | |||
Build formula using field values as text in the formula referencing another workbook | Links and Linking in Excel | |||
Regression Leverage Formula (Jerry W. Lewis or Mike Middleton)already have DFITS formula | Excel Worksheet Functions | |||
Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
Commenting custom formula fields/formula on formula editor | Excel Programming |