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.

=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.

=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.

Doesn't that produce the same result as the formula I give?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Toppers" wrote:

=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.

YES! ... just a different solution based on functions the OP mentioned.

"Dave F" wrote:

Doesn't that produce the same result as the formula I give?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Toppers" wrote:

=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.

Ah, got it.
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Toppers" wrote:

YES! ... just a different solution based on functions the OP mentioned.

"Dave F" wrote:

Doesn't that produce the same result as the formula I give?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Toppers" wrote:

=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.

Thanks Dave, I was almost there, but you saved me some precious time.

"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.

Put your Standards in three cells for example cell A1 has the standaerd L.
cell A2 has the standard a. and cell A3 has the standard b. Now put your
color smaple you want to compare to L. in cell B1, a. in cell B2 and the b.
in cell B3. The formula will read
=(((A2-A1)*(A2-A1))+((B2-B1)*(B2-B1))+((C2-C1)*(C2-C1)))^(1/2)

"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.