Return to Question

added 10 characters in body

Source Link

edited Oct 10, 2021 at 6:35

For an IBAN Validation, I need to calculate the modulo of a very large number. What I am doing is simply

Example:

with A1 = 210501700012345678131468A1 = 210501700012345678131468

=mod(A1;97)=mod(A1;97)

The result should be 11. Instead it result in #NUM#NUM

Obviously my value in A1A1 is too large for sheets. How can I "help" sheets?

For an IBAN Validation, I need to calculate the modulo of a very large number. What I am doing is simply

Example:

with A1 = 210501700012345678131468

=mod(A1;97)

The result should be 1. Instead it result in #NUM

Obviously my value in A1 is too large for sheets. How can I "help" sheets?

For an IBAN Validation, I need to calculate the modulo of a very large number. What I am doing is simply

Example:

with A1 = 210501700012345678131468

=mod(A1;97)

The result should be 1. Instead it result in #NUM

Obviously my value in A1 is too large for sheets. How can I "help" sheets?

Source Link

asked Oct 9, 2021 at 22:07

Calculating the modulo of large numbers in Google Spreadsheets

For an IBAN Validation, I need to calculate the modulo of a very large number. What I am doing is simply

Example:

with A1 = 210501700012345678131468

=mod(A1;97)

The result should be 1. Instead it result in #NUM

Obviously my value in A1 is too large for sheets. How can I "help" sheets?

google-sheets