Coding for prime number in Visual Basic

Asked By chavez sims 0 points N/A Posted on - 02/11/2013

Which website displays a list of helpful tips about coding for prime number in Visual Basic? Is it also possible to choose all prime numbers in Microsoft Excel?

 

• Status: Open
• Question Views: 876
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Visual basic

Best Answer by Matthew B Brown

Go To Solution

Answered By Cashh Zachary 0 points N/A #157183

Coding for prime number in Visual Basic

I found this array formula at Chip Pearson’s site:

=IF(OR(C8=2,C8=3),”prime”,IF(AND((MOD(C8,ROW(INDIRECT(“2:”&INT(SQRT(C8)))))<>0)),”prime”,”not prime”))

This formula is slightly amended from the one on Chip’s site, which treated 1 as a prime, and divided by all numbers up to C8-1, rather than SQRT(C8)

About Cashh Zachary

Questions
0

Answers
101

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 02/14/2013
• Question Category: Visual basic

Best Answer

Best Answer

Answered By Matthew B Brown 10 points N/A #157184

Coding for prime number in Visual Basic

Hello,

Visual Basic is a very user friendly language and so is excel. When I have trouble using such software, I always view the help option in the software. For example you could find commands for almost anything in excel in built help system.

However, as per your request please consult the following links for tips about coding for prime number in Visual Basic:

http://techforum4u.com/entry.php/600-VB-Program-To-Find-Whether-A-Number-is-Prime-Or-Not

http://www.programmersheaven.com/discussion/410507/calculate-prime-numbers-help 

And for excel:

http://www.bluemoosetech.com/microsoft-excel-functions.php?jid=29

Hope that helps!

About Matthew B Brown

Questions
7

Answers
35

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 03/09/2013
• Question Category: Visual basic