Normalizes to one hundred percent.
STANDARDIZE requires three arguments and normalizes a value that lies between a minimum and maximum value. The calculation is made as follows:
The first argument represents the value, the difference of the two following ones the range that is normalized to one hundred percent.
(Value - Minimum) / (Maximum - Minimum)
STANDARDIZE is mainly used for a cell with conditional formatting to highlight the maximum value reached by not coloring the cell at all, coloring it partially, or coloring it completely.
Example
STANDARDIZE(2;0;10) equates to (2-0)/(10-0) and results in 0,2
STANDARDIZE(7;3;10) equates to (7-3)/(10-3) and results in 0.571