Calculate checksum in Excel - how it works
There are many pre-built formulas in Excel, but none of them can be used to calculate checksums. We show you how to get the value you are looking for.
Excel: Calculate checksum
Despite the fairly simple calculation, Excel does not offer the possibility of directly calculating checksums. You have to type in the formula yourself, which in many cases will take longer than calculating the values yourself.
- For example, put the number 45 in cell A1. To calculate the checksum, enter the following command in cell B2: "= PART (A1; 1; 1) + PART (A1; 2; 1)".
- Generally speaking, the first two digits of the number in cell A1 are now added, that is, the checksum is formed. However, this formula now only applies to two-digit numbers.
- For a three-digit number you would have to add another part, the command then looks like this: "= PART (A1; 1; 1) + PART (A1; 2; 1) + PART (A1; 3; 1)". For numbers with more than one digit, you have to expand the formula accordingly.
- If you want to calculate the checksum from a table of numbers with the same number of digits, you only have to enter the formula once. Then you can select the field with the result and drag it down at the bottom right of the cell. How to copy the formula.
- However, if a number has more or fewer digits than specified in the formula, the checksum can either not be calculated or can only be calculated incorrectly.
This practical tip shows you how to create a diagram from a table of data in Excel.