How do I write an Excel formula for Delta E difference between
=SQRT(SUMSQ(L1-L2,A1-A2,C1-C2))
"Dave F" wrote:
=sqrt((l1-l2)^2+(a1-a2)^2+(b1-b2)^2)
Note you don't need SUM here. Each of the values being squared will sum
without the SUM function because you have the + symbols telling XL to sum.
Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
"dragon_girl411" wrote:
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.
|