| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the prime numbers?
True, I was working from memory (core needs replacing)
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Roger Govier" <rogerattechnology4NOSPAMu.co.uk wrote in message ... Hi Bernard Nice solution, but I think it works without being array entered. -- Regards Roger Govier "Bernard Liengme" wrote in message ... No need for VBA this time: =IF(SUMPRODUCT(--(MOD(A1,(ROW(INDIRECT("2:"&INT(SQRT(A1))))))=0))," Not Prime","Prime") must be array-entered (ie with SHIFT+CTRL+ENTER) best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Eric" wrote in message ... Does anyone have any suggestions on how to determine the prime numbers? There is a given number 10 in cell A2, I would like to determine the next prime numbers below and over this given number 10. In this case, 11 will be returned in cell A1, and 7 will be returned in A3. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to determine the top 5 occurrences from a list of numbers? | Excel Discussion (Misc queries) | |||
| How to determine the formula to generate following numbers? | Excel Discussion (Misc queries) | |||
| How to determine the frequency of a list of numbers? | Excel Discussion (Misc queries) | |||
| how to determine if a series of numbers contain odd or even values | Excel Worksheet Functions | |||
| How do I determine which numbers in a list equal a given sum? | Excel Discussion (Misc queries) | |||
Hybrid Mode
