Hi,
I've been reseraching for a good couple of weeks now but can't find the information i need to work this one out.
I'm not even sure if i'll be able to explain clearly what i'd like to be able to do.
I've attached my current spreadsheet as it is.
Untitled.jpg
What i'd like to do is be able to add up the cost of a wedding album based on various options chosen by my customers to make it as simple and as clear as possible for them.
The customer would chose the album name, the album size, the page count, type of paper and thickkness and then the formula would work out the cost based on the set prices for each option given by the album supplier.
The problem im coming up with is the variable side of it so to try and explain a bit more...
The same album, same size with 60 pages is obviously going to cost more than one with 40 pages, but that could then depend on the type of paper and thickness chosen for that album.
I hope that makes sense, in my head it does anyway. I'd be so grateful for any help with this so if you can and dont mind it'd be very much appreciated, if you need more information please ask. Thank you so much in advance, Stuart.
Bookmarks