How to calculate numbers involving big powers?

%3CLINGO-SUB%20id%3D%22lingo-sub-3325861%22%20slang%3D%22en-US%22%3EHow%20to%20calculate%20numbers%20involving%20big%20powers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3325861%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20you%20explain%20how%20to%20calculate%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20remainder%20when%20(11%5E2022%20%E2%88%92%205%5E2022)%20is%20divided%20by%2027%3F%3C%2FP%3E%3CP%3EI%20tried%20this%3A%3C%2FP%3E%3CP%3E%3DMOD((11%5E2022-5%5E2022)%2C27)%3C%2FP%3E%3CP%3EIt%20shows%20%23NUM!%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20with%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3325861%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3326220%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20numbers%20involving%20big%20powers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3326220%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382135%22%20target%3D%22_blank%22%3E%40HARSHV3J%3C%2FA%3E%26nbsp%3BNot%20sure%20here%20but%2011%20to%20the%20power%20of%202022%20is%20a%20very%20big%20number%20and%20exceeds%20Excels%20limits.%20What%20exactly%20are%20you%20trying%20to%20achieve%20here%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3326473%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20numbers%20involving%20big%20powers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3326473%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382135%22%20target%3D%22_blank%22%3E%40HARSHV3J%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20has%20been%20a%20video%20recently%20on%20Computerphile%20about%20big%20powers%20and%20modulo.%20Maybe%20it's%20useful.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DcbGB__V8MNk%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ESquare%20%26amp%3B%20Multiply%20Algorithm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3326595%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20numbers%20involving%20big%20powers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3326595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1382135%22%20target%3D%22_blank%22%3E%40HARSHV3J%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20is%20correct.%20The%20highest%20power%20of%2011%20that%20you%20can%20calculate%20in%20Excel%20is%2011%5E296.%3C%2FP%3E%0A%3CP%3E11%5E2022%20would%20be%20a%20number%20with%202106%20digits...%3C%2FP%3E%0A%3CP%3EYou'll%20need%20a%20mathematics%20application.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3329226%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20numbers%20involving%20big%20powers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3329226%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%20%2C%20this%20is%20a%20Mathleague%20question%20and%20I%20would%20like%20to%20check%20the%20answer%20using%20Excel.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3329228%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20calculate%20numbers%20involving%20big%20powers%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3329228%22%20slang%3D%22en-US%22%3EThank%20you.%3C%2FLINGO-BODY%3E
New Contributor

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?

5 Replies

@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?

@HARSHV3J 

There has been a video recently on Computerphile about big powers and modulo. Maybe it's useful.

Square & Multiply Algorithm 

 

@HARSHV3J 

@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.

@Riny_van_Eekelen , this is a Mathleague question and I would like to check the answer using Excel.
Thank you.