| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Imposing a limit on Min function
I have a variety of bids and am attempting to pick the lowest bid above a
minimum of 50% of the current price (since presumably anything less isn't feasible). Currently I have this function: =IF(MIN($BF3:$IV3)=0,"",MIN($BF3:$IV3)) and would like to make the last value be the minimum down to 50% of the price in cell D3. Thanks very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit a cell to except a function only. | Excel Worksheet Functions | |||
| How can I get around 30 argument limit of SUM function? | Excel Worksheet Functions | |||
| IF limit reached... what function would be better? | Excel Worksheet Functions | |||
| IF function - limit to the number of IFs? | Excel Discussion (Misc queries) | |||
| IF Function Help due to 7 limit | Excel Worksheet Functions | |||
Threaded Mode
