 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006DeltaE formula
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* 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* 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 > [quoted text clipped - 7 lines] >> >> The answer is 13.71 it has to do with color L*a*b* 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  SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > 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* 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. Signaturecan 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* Or enter the numbers 11.1, 6.1 and 5.25 in A1, A2 and A3 use formula =SQRT(SUMSQ(A1:A3)) best wishes SignatureBernard V Liengme www.stfx.ca/people/bliengme remove caps from email > 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* |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.