I am looking for the code to calculate the Z Prime/Z factor for a compound analysis plate. Does anyone have this information.

Thank you

Thank you

- Trial & error
- How do I find prime factors of a number
- Outputting factors and prime factors of number into one cell
- Smallest prime factor of a number
- Prime factors regardless of number length
- Decomposition in Prime Factors
- Factorization
- Prime Number just for fun
- How to lock the rows coulms so I can rearrange word from A to Z
- Retrieving a Value Based on 2 Lookup Factors
- DB2PORTAL Blog: New Built-in Functions [DB2 9 for z/OS]
- Leasing Factor With Variable Interest Rate
- Test If Number Is Prime Number
- Rounding Up By A Factor
- Spin Buttons To Change Tolerance Factor
- Web Data By Msie Shell.application
- Code for creating mersenne primes and perfect numbers...
- SUM column z where some entries have text "+" in them
- Calculate cost based on conditional weight factor
- Formulas: How can i lock a cell to another cell so when A-Z
- Determine If Number Is A Prime Number
- Help with ugly numbers...
- Interest Factor Tables?
- Formula For Pv Factor

EggHeadCafe - .NET Developer Portal of Choice

http://www.eggheadcafe.com

I also will need in the next step produce Prime factors in one single cell. Eg A1=12 B1=2, 2, 6

Sorry if it's been asked before, but I've had a search and can't quite find what I need.

Thanks in advance!

Is there any formula witch i can use to find the smallest prime factor of a number?

Example: In A1 i write 30 (30=2*3*5 (the prime factors))

in B1 i write a formula, and the result will be 2 (smallest prime factor)

What is the formula?

Searching through the forums, I've found a post of daddylonglegs, witch shows how to find the smallest factor of a number:

This,(as dll says), works only to 2^28-1 , because of an error of MOD formula.

I wanted to ask you for the formula (if it exists) witch can search the prime factor of a number regardless of it's length.

Is there anything like this?

I am looking for a script to decompose a list of numbers into their prime factors.

Attached is a file with an example of what I am looking for.

Thanks for your help,

Philippe

I found this on the Internet and would like to make it work.

I placed the formula in cell B1 and the number to be examined in A1 however

it evaluates primes and non-primes as TRUE.

Obviously, I have done something wrong.

Can anyone steer me correctly?

Paul

POWER FORMULA TECHNIQUE

by Bob Umlas

This array formula returns TRUE if the number in cell A1 is a prime number.

=OR(A1=2,A1=3,ISNA(MATCH(TRUE,A1/ROW(INDIRECT("2:"&INT(SQRT(A1))))=

INT(A1/ROW(INDIRECT("2:"&INT(SQRT(A1))))),0)))

Use it as a conditional formatting formula, with A1 as the active cell

in the selection to be formatted.

Here's how Bob's amazing formula works. In a nutshell, the number is

divided by all potential prime factors, and the resulting array is tested

to see whether it contains a whole number. If is does, you have a prime

number. A limitation of this formula is that it cannot test numbers that

are greater than 65535^2. This is due to the array size constraint in

Excel 97/2000.

DB2PORTAL Blog News, views, and items of interest on DB2 database management and mainframe systems.

i thought of testing with the mod function in an adjacent cell...but i'm not sure how to do...?

???

thank you.

Chris

I am just getting into VBA mainly as a hobby so bear with me.

I have attached a form which is part of a larger form I am working on.

The user enters a heat output in the shaded text box and depending on the tolerance factor (default of 10%) a upper and lower range is calculated and displayed.

What I cant get to happen is when the tolerance is changed using the spin buttons, the upper and lower ranges are not updated.

VB:I have tried running the same code for the txtoutput_change event against the txttolerance_change event but it doesnt work rightSpinButton1_SpinDown() txtTolerance.Value = SpinButton1.Value End Sub Private Sub SpinButton1_SpinUp() txtTolerance.Value = SpinButton1.Value End Sub Private Sub txtOutput_Change() Dim upper As Integer Dim lower As Integer On Error Resume Next OnlyNumbers 'calculate the values upper = txtOutput.Value + (txtOutput.Value / 100) * txtTolerance.Value lower = txtOutput.Value - (txtOutput.Value / 100) * txtTolerance.Value 'display the values txtUpperLimit.Value = upper txtLowerLimit.Value = lower End SubIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

Any ideas?

I am using the VBA code below. If you have any ideas, please let me know. I've tried some methods from the MSDN web site but I am missing something. http://tinyurl.com/1tri

Of course once I get this information, I hope to submit the form with the completed information.

VB:) Dim IE As Object, z As Object Dim oTable As Object, i As Integer, j As Integer Set IE = GetHTMLDocument(webSite) With IE 'IE.Document For Each z In .all Debug.Print "z.ID=" & z.ID Debug.Print "z.tagName=" & z.tagName Debug.Print "z.innerText=" & z.innerText If z.ID = "Table3" Then Set oTable = z Next z 'Debug.Print "oTable.Rows.Length=" & oTable.Rows.Length '=1 For i = 0 To oTable.Rows.Length - 1 For j = 0 To oTable.Rows(i).Cells.Length - 1 Debug.Print "row" & i & " cell" & j & "=" & oTable.Rows(i).Cells(j).innerText Next j Next i End WithIf you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines

code for creating mersenne primes and perfect numbers...

i'm looking for....????

thank you.

i'm looking for....????

thank you.

1.3

1.6

2.5

1.5+

1.6

Now when I sum it fails due to the text "+" if I use a substitute to change the + to a blank it transforms it all to text so will not sum. Unfortunately the structure of the sheet is fixed so it will have to be a function or UDF (excel 2010)

Any help appreciated.

The weights are as below:

upto 1kg = £8.14 (cell Z1)

2 - 10kgs = £0.27 (cell Z2)

11 - 100kgs = £0.14 (cell Z3)

If i had an item that weighs 20kgs (cell A1) the cost to delvier it should be £11.97 however the formula below is not throwing this out becuase i have done it wrong and i am struggling to get my head around it. i am duplicating the weight in the formula.

=IF(A1

If i have a name for instance : Joe Bloggs in one cell and his phone number in Another cell how when i add another name at the bottom and number can i A-Z by the names and get the relating phone number to stick with that cell?

Or more complicated... a IF AND formula that can tell me if the name joe bloggs appears in A2 and the number 1 appears in B2 put the number 34 but if the name is different but B2 is still 1 put nothing......that will stay relating to the name when A-Z??? I dont know if that makes any sense but any help would be great!!

I have a column of random number in Column A and need a formula to identify if any of the numbers in Col A is a prime number. If it is, then say "Prime" in the cell adjacent to the prime number in Col B. Eg if A12 has a value 17, then cell B12 should say "Prime".

thanking you

Suju

do any of you know how to make a vba program that will find the first "n" ugly numbers or 5-smooth numbers? what the program does is that it asks for an integer "n" and then lists the first "n" integers...

btw, ugly numbers are numbers whose only prime factors are from the set {2,3,5} and by convention, 1 is the first ugly number...

Thanks in advance