Calculating the modulo of large numbers in Google
Oct 09, 2021 · 1. If all of your number-strings are 24 digits/characters in length, you should be able to use this: =MOD( (MOD(LEFT(A2,12),97) * MOD(10^12,97)) + MOD(RIGHT(A2,12),97) ,97) If your divisor will change, you can substitute each instance of 97with a cell reference and then simply change the cell reference. Share.
DA: 10 PA: 100 MOZ Rank: 19