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