Hi
Hopeing someone can help.
I am trying to get a closet value in a table into another cell.
Example is Selling Apples. We sell apples in Packs of 2,4,6
We sell the pack sizes of apples in QTY of 10,20,30,40.
I am trying bring in the closet value if someone chooses a QTY of 23. Excel would...