| 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 | |||
Linear Mode
