For an IBAN Validation, I need to calculate the modulo of a very large number. What I am doing is simply
A1 = 210501700012345678131468
The result should be
1. Instead it result in
Obviously my value in
A1 is too large for sheets. How can I "help" sheets?