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