=(((B1-A1)^(2))+((B2-A2)^(2))+((B3-A3)^(2)))^(1/2)

Just to mention another way as a worksheet function: (I find easier to read)

=SQRT(SUMSQ(B1-A1,B2-A2,B3-A3))


Just to mention...you are using the formula..
[(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5

with a variable SL = 0.511

It was mentioned here a while ago that the equation does not appear
correct. There is no variable "lSL"
It appears to be something like:

(DL * / (L*SL))^2 ...etc
(C*SC)...etc

I may be wrong thou...

= = = =
Dana DeLouis



Robert wrote:

"Robert" wrote:

I finnally got it worked out. Say your standard is in cells A1 for L., A2 for
a., and A3 for your b. Your test sample is in cells B1 for L., B2 for a., and
B3 for the b.
Here is the formula I am useing note there may be other ways to write it but
I know this works.
=(((B1-A1)*(B1-A1))+((B2-A2)*(B2-A2))+((B3-A3)*(B3-A3)))^(1/2)
It could probably be written this way as
well=(((B1-A1)^(2))+((B2-A2)^(2))+((B3-A3)^(2)))^(1/2)

"Michelle7890" wrote:

Does anyone out there have the Delta E cmc formula for excel? I am trying to
set up a spreadsheet that compares colors of test samples to a reference
sample in a spreadsheet. But my excel skills are not this good.
Thanks,
Michelle
CMC = [(DL* / lSL)^2 + (DC*ab / cSC)^2 + (DH*ab / SH)^2]^0.5

whe

SL = 0.040975L* / (1+0.01765L*) unless L < 16 when SL = 0.511
SC = 0.0638C*ab / (1+0.0131C*ab) + 0.638
SH = (fT + 1 - f)SC

whe

f = [(C*ab)^4 / {(C*ab)^4 + 1900)}]^0.5
T = 0.36 + |0.4 cos(hab + 35)|
unless h is between 164 and 345 degrees when
T = 0.56 + |0.2 cos(hab + 168)|