I work for a commercial print company and my boss wants me to create a
spreadsheet for reading color data off of press sheets. I need to write a
formula for the DeltaE difference between two colors that are measured in
L*ab. The formula for finding DeltaE is (L1-L2) squared, + (a1-a2)squared,
+(b1-b2)squared; then finding the square root of the total. I just can't
figure out how to use the SUMSQ and SQRT formulas (I'm fairly new to Excel).
Is there anyone out there that can help.