I know you can combine multiple if statements in Excel. But is there an alternative to this problem:
I want to calculate a price of a printjob, based on several variables:
- paper thickness (300g, 200g, 150g, ...)
- paper size (SRA3, A4, ...)
- recto / verso print
- color / black and white
- number of prints (0 - 50 ; 50 - 100; > 100)
So the user of the document just has to select these things, and the price has to be calculated based on the choices he made.
The prices are held in a different worksheet per paper thickness. So there's a worksheet for 300g with all the prices there, a worksheet with 200g, ...
I added a screenshot of the choices you can make:
Any help to effectively calculate the price? Thanks in advance.
Edit: Cross reference table example
Aucun commentaire:
Enregistrer un commentaire