Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return lowest quantity
Example:
J16 = 174 L16 = 26 O16 = 30 Formula: =J16-L16 returns 148 If O16 were to be included in the above formula and the value in O16 is less than 148 then return 30 to the cell. In the other hand if the result from the formula =J16-L16 were return less than 30 then O16 would not return 30 I hope you can make sense to what I wish to accomplish. If not please let me know. Pat |
#2
|
|||
|
|||
Pat
If my interpretation of your question is OK: =MIN(O16,J16-L16) HTH Steve "Pat" wrote in message ... Example: J16 = 174 L16 = 26 O16 = 30 Formula: =J16-L16 returns 148 If O16 were to be included in the above formula and the value in O16 is less than 148 then return 30 to the cell. In the other hand if the result from the formula =J16-L16 were return less than 30 then O16 would not return 30 I hope you can make sense to what I wish to accomplish. If not please let me know. Pat |
#3
|
|||
|
|||
Steve,
Your interpretation is correct. Many Thanks Pat "Steve R" wrote in message ... Pat If my interpretation of your question is OK: =MIN(O16,J16-L16) HTH Steve "Pat" wrote in message ... Example: J16 = 174 L16 = 26 O16 = 30 Formula: =J16-L16 returns 148 If O16 were to be included in the above formula and the value in O16 is less than 148 then return 30 to the cell. In the other hand if the result from the formula =J16-L16 were return less than 30 then O16 would not return 30 I hope you can make sense to what I wish to accomplish. If not please let me know. Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
RETURN intersecting value with known horizotal & vertical?? | Excel Worksheet Functions | |||
Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
Return the smallest value | Excel Worksheet Functions | |||
How can I get the lowest price, second lowest etc. from a range o. | Excel Worksheet Functions |