mercredi 23 décembre 2015

Combining multiple if statements in Excel

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:

enter image description here

Any help to effectively calculate the price? Thanks in advance.

Edit: Cross reference table example enter image description here

Aucun commentaire:

Enregistrer un commentaire