I am working on a costing model for the manufacturing company I work for. The costing is linked to a large matrix of machine output standards. These standards work for most of our business but have established that 2 scenarios that change the standard outputs. I have therefore added 2 drop down boxes 1) Embossed: YES OR NO 2) Roundel label: YES OR NO
Putting embossed paper through the machine reduces the output to 75%
Adding a particular label reduces the output to 66% for all papers even if embossed! All the rest are 100%
So I have linked all the outputs in the matrix to one cell, currently hardcoded with 100%. I need to replace the 100% with a formula that basically looks up: if the label is YES then 66%, if label NO but embossed YES then 75%, if NO label and NO emboss then 100%. Can anyone help me get this into one nested formula? Many thanks![]()
Bookmarks