DeltaE formula

[Frank Malone]

can someone show me how to enter this formula in excel.
=[(+11.1)^2+(-6.1)^2+(-5.25)^2]1/2

The answer is 13.71 it has to do with color L*a*b*

 

[Guest]

Frank

=SQRT((11.1)^2+(-6.1)^2+(-5.25)^2)

regards
Peter

 

[Bernard Liengme]

a) =((11.1)^2+(-6.1)^2+(-5.25)^2)^(1/2)
b) =SQRT((11.1)^2+(-6.1)^2+(-5.25)^2)
answer is 13.71067102661

 

[Jim Reed]

You left out the exponent "^" sign before the last exponent of 1/2.

Also, either put the fractional exponent in parentheses, or use 0.5 instead. Otherwise, Excel will raise the expression to the first power, and then divide the entire expression by 2.

--

can someone show me how to enter this formula in excel.
=[(+11.1)^2+(-6.1)^2+(-5.25)^2]1/2

The answer is 13.71 it has to do with color L*a*b*

 

[Bernard Liengme]

Or enter the numbers 11.1, 6.1 and 5.25 in A1, A2 and A3
use formula =SQRT(SUMSQ(A1:A3))
best wishes

 

[Frank Malone]

Sure thank everyone for the help. I did recheck the way I entered formula
and it was that way in the book. I would never knew to drop the 1/2 and to
use SQRT

Frank

=SQRT((11.1)^2+(-6.1)^2+(-5.25)^2)

regards
Peter

can someone show me how to enter this formula in excel.
=[(+11.1)^2+(-6.1)^2+(-5.25)^2]1/2

The answer is 13.71 it has to do with color L*a*b*