Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formatting answers in Ratio format

3 views
Skip to first unread message

Anne Walsh

unread,
Jul 9, 2002, 3:43:55 AM7/9/02
to
Hi
Is this doable in Excel??
If I have two figures, let's say 100 and 10 and I would like to express them
in Excel as follows 10:1 i.e. as a ratio. Is this doable? Without getting
deep into VBA?
Answers much appreciated!
Thanks
Anne


Paul Watson

unread,
Jul 9, 2002, 4:58:55 AM7/9/02
to
You don't need VBA at all. If A1= 100 and B1 = 10, then make C1 =A1/B1 &
":1"
"Anne Walsh" <abal...@eircom.net> wrote in message
news:ZrwW8.781$zX3...@news.indigo.ie...

Jim Becker

unread,
Jul 9, 2002, 11:26:09 AM7/9/02
to
I don't think you can do this with a Number Format.
Here is a worksheet formula that seems to do the trick.
It uses the GCD function from the Analysis Tool Pack.

=(A2/GCD(A2,B2)&":"&B2/GCD(A2,B2))

Hope this helps,
James dot Becker at NCR dot com
~
~
~
:wq!

"Anne Walsh" <abal...@eircom.net> wrote in message
news:ZrwW8.781$zX3...@news.indigo.ie...

Dana DeLouis

unread,
Jul 9, 2002, 2:12:14 PM7/9/02
to
Can you get by with a custom format?

???/???

Displays as 10/1, and not 10:1 as you wanted though.
Note: It also shows up in the Text property of a cell.

Debug.Print [C1].Text
10/1
--
Dana DeLouis
Windows XP & Office XP
= = = = = = = = = = = = = = = = =


"Anne Walsh" <abal...@eircom.net> wrote in message
news:ZrwW8.781$zX3...@news.indigo.ie...

Anne Walsh

unread,
Jul 15, 2002, 3:41:56 AM7/15/02
to
Just a quick note to say "Thank you" for your replies to the Ratio
problem. I reckon the Tool Pack one gives me just the answer I'm looking
for.....
Thanks
Anne

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

0 new messages