Finding the Best Price

M

Midd

I am creating a spreadsheet that will show me what suppliers give me the
best price. There are three companies that supply me and i want to be
able to type in each of their prices and the spreadsheet gives me back
the cheapest price. At the moment i have been trying different if
statements but can't get it to work.
 
B

Barb R.

Can you give us a bit more information as to what you have in your
spreadsheet? It's difficult to answer appropriately without knowing what
you have set up already.
 
B

BenjieLop

Midd said:
I am creating a spreadsheet that will show me what suppliers give me th
best price. There are three companies that supply me and i want to b
able to type in each of their prices and the spreadsheet gives me bac
the cheapest price. At the moment i have been trying different i
statements but can't get it to work.
Click to expand...


Assuming that all the quoted prices are in, for example, Cells B1:B3
the lowest price can be determined with this formula

=MIN(B1:B3

You can modify this formula to suit your needs.

Regards
 
Top