Assign value to list
- by Kenneth B
Hello
First and foremost. I'm totally new to "programming" in Excel.
I'm trying to make a price calculator, that calculates the price when I use my printer.
I have made some lists so it's easy to perform the calculations.
Single or duplex: Singlex/Duplex
Format: SRA3 / A4 / SRA3 High Gloss
The idea is that if I type in an amount of 100 prints, choose SRA3 format on the list, and choose Duplex on the other list. the calculation would look like this:
This is how it's calculated:
Paper + (print x sides) = Price of the print job
Print prices
Per page (singlex or duplex): 0,6
Paper format and price:
A4 reg. paper: 0,2
SRA3 High Gloss: 1,25
SRA3 reg. paper: 1
Does anyone know about this???