Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Calculate Delta E Color in Excel (4 Suitable Methods)

If you want to find out the color difference between two samples, then you should calculate Delta E Color in Excel. So, if you are looking for how to calculate Delta E Color in Excel, then you have come to the right place. Today, in this article, I will demonstrate how to calculate Delta E Color in Excel.

Furthermore, for conducting the session, I will use Microsoft 365 version.


Download Practice Workbook

You can download the practice workbook from here:


What Is Delta E?

Here, E represents “Empfindung”. Actually, Empfindung is a German word that means sensation. On the other hand, Delta is a Greek word that denotes the gradual change of a variable. So, this Delta E represents changes in sensation.

Basically, you can measure Delta E on a scale from 0 to 100. Where 0 denotes less color difference. On the other hand, 100 means full distortion. Moreover, the usual perception ranges explained by Zachary Schuessler are given below:

  • <= 1.0: Not sensible by the human eye.
  • 1-2: distinguishable through close attention.
  • 2-10: Perceptible at first sight.
  • 11-49: Colors are comparable to the opposite.
  • 100: Colors are definitely the opposite.

4 Methods to Calculate Delta E Color in Excel

Here, I will demonstrate four suitable methods with detailed steps on how to calculate Delta E Color in Excel. For your better understanding, I am going to use the following dataset. Which contains three columns. These are Terms, Reference Value, and Measured Value. The dataset is given below.

Dataset on How to Calculate Delta E Color in Excel

Actually, the three terms L, a, and b represent three axes for color difference.

  • Where L denotes darkness (0 as the initial value) to lightness (100 as the last value).
  • Then, a means the shades of greenness (-128) to redness (+127).
  • On the other hand, b denotes the shades of blueness (-128) to yellowness (+127).

1. Use Generic Formula to Compute Delta E Color

You can use a generic formula to calculate Delta E Color in Excel. Now, follow the steps given below.

Steps:

  • Firstly, you must select a blank cell D9 where you want to keep the Delta E Color.
  • Secondly, you should use the formula given below in the D9 cell.
=((C5-D5)^2+(C6-D6)^2+(C7-D7)^2)^(1/2)

Actually, this is a simple algebraic formula. I have used some basic operations like subtraction, summation, and power.

Use Generic Formula to Compute Delta E Color in Excel

  • Then, press ENTER to get the result.
  • Finally, you will get the Delta E Color.

Read More: How to Calculate Delta in Excel (2 Ideal Examples)


2. Employ Excel SQRT Function for Color Calculation of Delta E

Here, I will use the SQRT function to calculate Delta E Color in Excel. Basically, I’m going to use just a modified version of the previous formula. So, follow the steps given below.

Steps:

  • Firstly, you must select a blank cell D9 where you want to keep the Delta E Color.
  • Secondly, you should use the formula given below in the D9 cell.
=SQRT((C5-D5)^2+(C6-D6)^2+(C7-D7)^2)

Here, in this formula, the SQRT function will return the square root of the summation of three terms. Where these three terms are the square of subtraction from reference value to measured value.

Employ Excel SQRT Function for Color Calculation of Delta E in Excel

  • Consequently, press ENTER.
  • As a result, you will get the Delta E Color.

Read More: How to Calculate Option Greek Delta in Excel (with Easy Steps)


3. Merge SQRT & POWER Functions to Calculate Delta E

Now, I will use the POWER function along with the SQRT function to calculate Delta E Color in Excel. Actually, this is the more updated version of the previous formulas. Let’s follow the steps given below.

Steps:

  • Firstly, you must select a blank cell D9 where you want to keep the Delta E Color.
  • Secondly, you should use the formula given below in the D9 cell.
=SQRT(POWER(C5-D5,2)+POWER(C6-D6,2)+POWER(C7-D7,2))

Merge SQRT & POWER Functions to Calculate Delta E in Excel

Formula Breakdown

  • Here, in this formula, the POWER function will return the output of a number raised to a specified power.
  • First, POWER(C7-D7,2)—> here the subtraction of measured value (D7) from the reference value (C7) is base, 2 is that specified power.
  • Output: 19.4481.
  • Similarly, POWER(C6-D6,2)—> gives 16.8921.
  • Then, POWER(C5-D5,2)—> turns 23.2324.
  • After that, the Plus sign (+) will add all three outputs.
    • Output: 59.5726.
  • Finally, the SQRT function will return the square root of the above output.

  • Consequently, press ENTER.
  • Lastly, you will see the Delta E Color.

Read More: How to Calculate Delta Delta CT in Excel (With Easy Steps)


4. Combine SQRT & SUMSQ Functions to Find Delta E Color

Here, I will use a combination of SQRT and SUMSQ functions to calculate the Delta E Color in Excel. So, follow the steps given below.

Steps:

  • Firstly, you must select a blank cell D9 where you want to keep the Delta E Color.
  • Secondly, you should use the formula given below in the D9 cell.
=SQRT(SUMSQ(C5-D5,C6-D6,C7-D7))

Formula Breakdown

  • Here, in this formula, the SUMSQ function will return the summation of the square of three terms.
  • Where these three terms are the subtraction from the reference value to the measured value.
  • So, SUMSQ(C5-D5,C6-D6,C7-D7)—> returns 59.5726.
  • Then, the SQRT function will return the square root of that output.

  • Subsequently, press ENTER to get the result.
  • As a result, you will get the Delta E Color.

How to Calculate Delta E Color in Excel with Combination of Functions


Practice Section

Now, you can practice the explained method by yourself.

Practice Section to Calculate Delta E Color in Excel


Conclusion

I hope you found this article helpful. Here, I have explained 4 suitable methods to calculate Delta E Color in Excel. You can visit our website Exceldemy to learn more Excel-related content. Please drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Musiha

Musiha

I am Musiha, graduated from Naval Architecture and Marine Engineering Dept., BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo