Calculate and find prime number with Excel . This posting include two example about the simplest method for finding all prime numbers.
1. Using formula IF(Mod,OR)
2. Using function GCD ( greatest common divisor) Returns the greatest common divisor of two or more integers.
This metode can applied without use script Visual Basic for Applicatin (VBA script). If you interest, you can download example excel files (see attachment files) to find prime numer using simple formula.