ITEM QTY AVAILABLE QUANTITIES
A B C D E
Product A 400 2500 1000 500
Is there a formula which will calculate the closest higher value based on the quantity in Col B?
In other words, need to find out if all of the available quantities are lower than 400, then keep 400. If the available quantities have an option that is higher than 400, return the closest highest value - in this case, 500.
A B C D E
Product A 400 2500 1000 500
Is there a formula which will calculate the closest higher value based on the quantity in Col B?
In other words, need to find out if all of the available quantities are lower than 400, then keep 400. If the available quantities have an option that is higher than 400, return the closest highest value - in this case, 500.