lundi 3 décembre 2018

Multiple three condition statement for determining printing cost

I am doing a printing cost project and it has three conditions to output the right price value. The conditions being the Size of paper, Colour or B&W (black and white) and Single/Double sided.

For example
 IF Size=8.5x11"  Color/B&W= B&W   Sided= Single  **result= 0.1** 
 IF Size=8.5x11"  Color/B&W= Color Sided= Double  **result= 0.4**
 IF Size=11x17"   Color/B&W= B&W   Sided= Single  **result= 0.25**

and so on, therefore I am not sure how to combine the three conditions into 1 big statement. I have attached the picture of the spreadsheet which has the rates written out.enter image description here

Aucun commentaire:

Enregistrer un commentaire