Ratio Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

or

=a1 & "/" & a2

jayseeca said:
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!
Click to expand...
 
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
 
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
 
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
 
Back
Top