prime

I am looking for a UDF to compute the nth composite number (nth non-prime number) similar to the nth prime. for e.g., 1st prime number is 2. 1st composite is 4. 10th prime number is 29. 10th composite is 18. 100th prime number is 541. 100th composite is 133.

<colgroup><col><col><col><col><col><col><col></colgroup><tbody> Telecast Date Telecast Day Day Start Time End Time Time Zone Answer 1-Aug-19 Thursday Weekday 7:00:00 12:00:00 Morning Prime Time 2-Aug-19 Friday Weekday 17:00:00 21:00:00 Evening 3-Aug-19 Saturday Weekend 13:00:00 16:00:00...

Say I have a number, for example 212, is there a formula which will find me a prime factor, preferably the smallest or else the largest, of that number (without counting 1 or the number itself)? In this case it would be 2. Note that the smallest factor of a number (again, not counting 1 or the...

hi guys, i have a question about Excel charts, can someone plz help? i have the two data sets below. i want to combine it into one chart, where i show stacked bars for each of mortgages, Lines, and Prime Based across time but then on the same chart at the top i want to include two lines for...

I have created a function PRIME(n) with Boolean output to check if a number is prime or not I am now looking to create a function that counts the prime numbers between two numbers n1 and n2 Help much appreciated!

Hello! I have a worksheet including a table (see the below link) with more similar / repeated sections, referring to some specific elements. The sections combine some titles with identic name (Materii prime pentru ………… and Subtotal costuri materii prime pentru ………………..), with other...

Greetings, I'm officially stumped on this one. I've searched numerous threads and cannot find what I'm looking for. I'd like a macro created that will copy or paste, whichever is less time consuming, entire rows into other sheets based on a range of alpha numeric characters found in column A...

Hi Guys :) I do these days an analytical research and i need some of help in this issue I need to find a way to extract the prime factors of numbers with some special conditions .. Let's take an example to make it much more clear IF i have an an integer number .. let's say 12682 I want to...

I know how to do the Conditional Formatting stuff for cells, but I need to make a cell that turns red if the number is a prime number. I just need to know if there is a formula that returns true if the value is a prime number and false if it isn't. And if you guys know of an add-in for excel...

I'm trying the google, "find the first 10 digit prime in the digits of PI problem" and I'm stuck. I have the logic for it but i keep running into mod errors. Some of this code is lifted as I crashed while doing my last itteration and am too fried to rewrite. Any help is appreciated. Sub...

Can anyone give me a formula that will count prime numbers in a range :confused: