URGENT

amitch

New Member
Joined
Dec 30, 2005
Messages
2
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
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

goblin

Active Member
Joined
Apr 16, 2003
Messages
469
=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
goblin said:
=A1/GCD(A1,B1) & ":" & B1/GCD(A1,B1)

You need the Analysis Toolpak addin (comes with Excel) active.

Merry Christmas,
Goblin

Well, nice, never even *suspected* the GCD function. :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,290
Messages
5,571,327
Members
412,382
Latest member
Langtn02
Top