Thread: Calculating ratios: Is there a formula that can do this?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Calculating ratios: Is there a formula that can do this?
Try =A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)
But that would be text and hence one would not be able to use the cell to do
further arithmetic.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"dshadrock" wrote in message
...
Is there a formula that will allow for a return value as a ratio, i.e.
2:1,
4:1 and so forth? This would be a great analytical tool.


Reply With QuoteReply With Quote