Help with a Formula
I’m trying to input deductions for a length according to which heading style and which track we will be using. Line 4 is trying to do the calculations accordingly as the track is column L – King Track, the heading is column B – Double Pinch Pleat and it is Face Fit.
The length is in this instance 2300. The deductions for Face Fix is 0, so the outcome should be 2300.
Screen Shot attached with the static data and the required allowances for each scenario.
I’m not sure if this is possible as there seems to be a lot of values required.
Thank you in advance. I do hope for an answer.
I’m trying to input deductions for a length according to which heading style and which track we will be using. Line 4 is trying to do the calculations accordingly as the track is column L – King Track, the heading is column B – Double Pinch Pleat and it is Face Fit.The length is in this instance 2300. The deductions for Face Fix is 0, so the outcome should be 2300.Screen Shot attached with the static data and the required allowances for each scenario.I’m not sure if this is possible as there seems to be a lot of values required. Thank you in advance. I do hope for an answer. Read More