Finding the Best Price

[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.

[MattShoreson]

could you use the worksheet function - MAX?

[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.

"Midd" wrote:

>
> 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.
>
>
> --
> Midd
> ------------------------------------------------------------------------
> Midd's Profile: http://www.excelforum.com/member.php...fo&userid=5423
> View this thread: http://www.excelforum.com/showthread...hreadid=384489
>
>

[BenjieLop]

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.

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.