Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the Best Price
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
could you use the worksheet function - MAX? -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=384489 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy old price data onto new stock list if match exists? | Excel Discussion (Misc queries) | |||
Mix, Volume and Price impact on revenue | Excel Discussion (Misc queries) | |||
Macro's for figuring Price Lists?!? | Excel Discussion (Misc queries) | |||
Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
Computing Sales Tax and Retail Price from a number | Excel Worksheet Functions |