| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How to make "common factor" formula ?
Hi,
I'm an Excel newbie. I want to make a simple "common factor" formula. But I don't know what function to use or the formula. Example A1 = 369 A2 = 468 A3 = common factor is 6 Another Example A1 = 355 A2 = 145 A3 = 225 A4 = common factor is 5 Thank You. |
|
#2
|
|||
|
|||
|
There's an =GCD() (greatest common divisor) in the analysis toolpak:
=gcd(369,468) returned 9. =gcd(a1:a3) (with your data in A1:A3) returned 5. If you get a #name! error, tools|Addins and check analysis toolpak. toyota58 wrote: Hi, I'm an Excel newbie. I want to make a simple "common factor" formula. But I don't know what function to use or the formula. Example A1 = 369 A2 = 468 A3 = common factor is 6 Another Example A1 = 355 A2 = 145 A3 = 225 A4 = common factor is 5 Thank You. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make some columns all caps and others proper? | Excel Discussion (Misc queries) | |||
| How can I make a timesheet to figure my hours and payrate? | Excel Worksheet Functions | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
Hybrid Mode
