| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF,AND,OR formula
Can't figure which combo of IF/AND, IF/OR, IF/AND/OR to use and not able to get the logic straight in the formula.
N2 is a weight price from an INDEX/MATCH formula N3 is the MIN price to be charged for N2 N4 is the MAX price to be charged for N2 If N2 is less than MIN then MIN If N2 is greater than MAX then MAX If N2 = Min OR N2 <= MAX then N2 (N2 is between MIN and MAX inclusive) Thanks, Howard |
| 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 | |||
Threaded Mode
