PLEASE READ BEFORE YOU ANSWER: ONLY Excel Formula Required: One formula that can be used to generate prime numbers (many

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

PLEASE READ BEFORE YOU ANSWER: ONLY Excel Formula Required: One formula that can be used to generate prime numbers (many

Post by answerhappygod »

PLEASE READ BEFORE YOU ANSWER:
ONLY Excel Formula Required:
One formula that can be used to generate prime numbers (many,
but not all) is x = n^2 + n + 41 where x is a prime number and n is
an integer. Plugging in consecutive integers 1, 2, 3...etc., up to
a point, will generate prime numbers. Using an Excel function,
calculate the smallest value of n where this equation fails to
produce a prime number. For the next 100 values of n, does the
formula continue to produce primes?
The smallest number is 40 at which the question will fail. So, i
know the answer and its easy to simply find but I need the
Excel Function only.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply