Ratio Formula
 

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

Ratio Formula
 

=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?

Ratio Formula
 

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!

"Daniel CHEN" wrote:


=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?

Ratio Formula
 

=a1 & ":" & a2

or

=a1 & "/" & a2

"jayseeca" wrote:

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!

"Daniel CHEN" wrote:


=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?

Ratio Formula
 

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

"Toppers" wrote:

=a1 & ":" & a2

or

=a1 & "/" & a2

"jayseeca" wrote:

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!

"Daniel CHEN" wrote:


=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?

Ratio Formula
 

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


"jayseeca" wrote:

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

"Toppers" wrote:

=a1 & ":" & a2

or

=a1 & "/" & a2

"jayseeca" wrote:

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!

"Daniel CHEN" wrote:


=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?

Ratio Formula
 

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

"jayseeca" wrote:

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

"Toppers" wrote:

=a1 & ":" & a2

or

=a1 & "/" & a2

"jayseeca" wrote:

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!

"Daniel CHEN" wrote:


=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?

Ratio Formula
 

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


--
tj


"jayseeca" wrote:

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

"Toppers" wrote:

=a1 & ":" & a2

or

=a1 & "/" & a2

"jayseeca" wrote:

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!

"Daniel CHEN" wrote:


=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
=================================
"jayseeca" wrote in message
...
I'm having trouble finding a formula in excel, to just create a ratio
between
values from 2 different columns.
Help please?