View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default I need help with ratios

Ah. You're absolutely right. I made the opposite assumption from you,
and there's no good reason for it.

If the OP wants integral divisors, and doesn't mind the result being
Text rather than a number (probably a good assumption):

=SUBSTITUTE(TEXT(A1/A2,"0/0"),"/",":")

(I don't know if that's been suggested already - didn't see it in *this*
thread).

In article ,
"Rick Rothstein \(MVP - VB\)"
wrote:

So the question is whether the OP wants the ratio to always be
against ':1' or not. Unfortunately, she did not give an example by
which we could decide.