Forum Discussion

MChan1330's avatar
MChan1330
Copper Contributor
May 11, 2022

Average STD 1.5 calculation

I received an Excel file and trying to figure out this formula that appears to calculate and identify an upper or lower limit from STD. =SUM(('Data'!$S2>= (SUM(('Data'!V$1*'Data'!$T2),'Data'!$U2)))...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
May 11, 2022

MChan1330 

mtarler has already explained the parts of the formula, but (apart from the large number of unnecessary parentheses) I don't understand what you're trying to calculate. Could you explain in plain words what you want to do?

mtarler's avatar
mtarler
Silver Contributor
May 11, 2022
I can't speak to why but it appears they are creating a column of numbers that will show for any data point within the tolerance (V1*T2 i.e. #STDs from the Average) a 0 and for any outside that tolerance how far outside that tolerance it is.

Resources