| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
creating a quote spreadsheet
I am trying to create a quote system using excel, and need to be able to select from a range of quantities and then select from a range of colours I have tried using index and match functions but this will only work if the quantites are the same as in the table.but i need to be able to select from a range of quantities 0-15 16-24 etc I cant use nested if statements as there are 12 quantity groups thanks in advance -- andyell ------------------------------------------------------------------------ andyell's Profile: http://www.excelforum.com/member.php...o&userid=35272 View this thread: http://www.excelforum.com/showthread...hreadid=550821 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating a quote spreadsheet
See a response to your multi-post in .worksheet.functions
(Please do not multi-post) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating a quote spreadsheet
Max, I cant log in to download these files? Andy PS Sorry for the multi post -- andyell ------------------------------------------------------------------------ andyell's Profile: http://www.excelforum.com/member.php...o&userid=35272 View this thread: http://www.excelforum.com/showthread...hreadid=550821 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating a quote spreadsheet
"andyell" wrote:
Max, I can't log in to download these files? Try it again, Andy. I've just re-uploaded into the same link, and tested the link ok. Sample construct at: http://www.savefile.com/files/5747910 Quote System 2 variables Tiered Qty by Colour.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
creating a quote spreadsheet
Here's an alternative link to the sample (just in case):
http://cjoint.com/?gnqbexXB3B Quote System 2 variables Tiered Qty by Colour.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy From One Spreadsheet To Another Spreadsheet | Excel Discussion (Misc queries) | |||
| inserting image and document files into the spreadsheet | Excel Discussion (Misc queries) | |||
| Displaying contents of cell on different spreadsheet | Excel Discussion (Misc queries) | |||
| how do you find a excel spreadsheet that you replaced with a new | Excel Worksheet Functions | |||
| Creating a link between cells in two different spreadsheets | Excel Discussion (Misc queries) | |||
Linear Mode
