Ratio Formula

[Guest]

I'm having trouble finding a formula in excel, to just create a ratio between
values from 2 different columns.
Help please?

 

[Daniel CHEN]

=B1/A1
Is this what you want?
Or be more specific.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================

 

[Guest]

i have 2 columns with large numbers, and i'm kinda looking for it to show up
in the cell looking like this:
"184:3930" or "184/3930"

thanks!

 

[Guest]

=a1 & ":" & a2

or

=a1 & "/" & a2

i have 2 columns with large numbers, and i'm kinda looking for it to show up
in the cell looking like this:
"184:3930" or "184/3930"

thanks!

 

[Guest]

thanks. i was wondering though... the numbers i'm working with are large, and
is there a way where it would turn into more of a "smaller" ratio?
ex: 10:500 would turn into 1:50

 

[Guest]

You'll need the Analysis ToolPak installed for this. Just click on TOOLS -->
ADD-INS --> Check "Analysis ToolPak" --> OK

Then you can use this formula:

=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)

HTH,
Elkar

 

[Guest]

Try this:

=A1/HCF(A1,B1) &":" & B1/HCF(A1,B1)

A1 and B1 are your numbers


Put the VBA code below in a general module:

Function HCF(ByRef n1 As Long, ByRef n2 As Long)
Dim n3 As Long
Do
n3 = n1 Mod n2
n1 = n2
n2 = n3
Loop Until n3 = 0
HCF = n1
End Function

 

[Guest]

How about =A1/GCD(A1:B1)&":"&B1/GCD(A1:B1) with the Analysis Toolpak insalled?