Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ratio Formula
I'm having trouble finding a formula in excel, to just create a ratio between
values from 2 different columns. Help please? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
assign formula to another cell | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
I need a formula to calculate the ratio of #'s in a row and column | Excel Discussion (Misc queries) | |||
Formula for Ratios | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel |