DeltaE formula

F

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*
 
B

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
 
J

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*
 
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
 
F

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

PeterAtherton said:
Frank

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

regards
Peter

Frank Malone said:
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*
Click to expand...
Click to expand...
 
Top