I have the attached spreadsheet with multiple columns of data. I'm wanting the column AK to be calculated based upon multiple criteria. Partially determined by the inputs in columns N and Y but also use the information in the two charts at the bottom of the worksheet.
My current formula gives me #value errors as the min function is based upon a cells value as well as two cells being multiplied. However, when multiplying the value, or in this case the %, may not always be applicable, and the input will be "n/a". When n/a is input, I still want the calculation to return the min of the other values that could be calculated.
My formula in AK is very long and it seems there should be a better way.
Bookmarks