#NUM! error in MOD function

P

pranabindu

Running the following modulus function in Excel results in the #NUM! error
for any n values above 14:

=MOD(5^n, 157)

Additional information: one column of integers from 1 through 156. Another
column with MOD function written on top cell and fill-handled for the rest of
the cells. The fill seems to have been done properly. When it gets to
=MOD(5^15,157), it starts with the #NUM! error. Nothing above 14 gets a
proper numerical result.

Any ideas?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top