A amitch New Member Joined Dec 30, 2005 Messages 2 Dec 30, 2005 #1 Hi I have the following data with me Cell A1 = 100 Cell B1 = 200 In Cell C1 I want to show the relation as a ratio, ie 1:2 how can i do that ? Regards amit
Hi I have the following data with me Cell A1 = 100 Cell B1 = 200 In Cell C1 I want to show the relation as a ratio, ie 1:2 how can i do that ? Regards amit
goblin Active Member Joined Apr 16, 2003 Messages 469 Dec 30, 2005 #3 =A1/GCD(A1,B1) & ":" & B1/GCD(A1,B1) You need the Analysis Toolpak addin (comes with Excel) active. Merry Christmas, Goblin
=A1/GCD(A1,B1) & ":" & B1/GCD(A1,B1) You need the Analysis Toolpak addin (comes with Excel) active. Merry Christmas, Goblin
just_jon Legend Joined Sep 3, 2002 Messages 10,473 Dec 30, 2005 #4 goblin said: =A1/GCD(A1,B1) & ":" & B1/GCD(A1,B1) You need the Analysis Toolpak addin (comes with Excel) active. Merry Christmas, Goblin Click to expand... Well, nice, never even *suspected* the GCD function.
goblin said: =A1/GCD(A1,B1) & ":" & B1/GCD(A1,B1) You need the Analysis Toolpak addin (comes with Excel) active. Merry Christmas, Goblin Click to expand... Well, nice, never even *suspected* the GCD function.
