May 05 2022 08:51 AM
Can you explain how to calculate
What is the remainder when (11^2022 − 5^2022) is divided by 27?
I tried this:
=MOD((11^2022-5^2022),27)
It shows #NUM!
Can you help me with this?
May 05 2022 09:11 AM - edited May 05 2022 09:14 AM
@HARSHV3J Not sure here but 11 to the power of 2022 is a very big number and exceeds Excels limits. What exactly are you trying to achieve here?
May 05 2022 09:53 AM
There has been a video recently on Computerphile about big powers and modulo. Maybe it's useful.
May 05 2022 09:59 AM
@Riny_van_Eekelen is correct. The highest power of 11 that you can calculate in Excel is 11^296.
11^2022 would be a number with 2106 digits...
You'll need a mathematics application.
May 05 2022 05:43 PM