| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
If Formula
I would like to create a formula that looks at four days on hand criteria and returns a value based on a band of days
Ex: if the lookup value is <=30 return "35" if the lookup value is between 36 and 40 return "25", if the lookup value is between 41 and 44 return "15" and if the lookup value is above 45 return "0" any help is most appreciated |
| 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) | |||
| 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 | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Commenting custom formula fields/formula on formula editor | Excel Programming | |||
Threaded Mode
