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.
Aucun commentaire:
Enregistrer un commentaire