I have an inventory database with a form and subform. On the main form has the inventory product information (ie: product ID, description, our selling price, etc...) On the subform lists all the suppliers that we get that product from along with their prices and part numbers. What I want to do is calculate our selling price based off of the suppliers prices. Each product can have one, two, or 3 suppliers. I want to calculate our cost as follows...

A 25% mark up based on the average of our suppliers pricing. How can I word this formula so that it will properly calculate the average based on the number of suppliers I have listed. So if there's two suppliers it will calculate "(Supplier1price + supplier2price)/2" and if there's three suppliers it will calculate "(Supplier1price+supplier2price+supplier3price )/3" or if there's just one supplier it will just take that one supplier's price and calculate our markup on just that one price...