FORMULAS for lowest cost on an item
I am creating a price sheet for our company.
I have price lists from our 3 distributors.
- I want to add our cost from each distributor in separate columns for each item.
- a retail price in a fourth column for each item which will not be included in the formula.
- I would like to have a 5th column that will show for each item that will show which of the 3 distributor columns has the lowest cost so we know where to order from.
any help would be greatly appreciated
