software

Is there a formula that will automatically work out two numbers as a ratio,
i.e. I want a sheet with numbers of sales calls, visits, sales, etc and to
automatically be able to see the no of calls to sales, calls to visits, etc -
I want to express as, i.e. 10:1 rather than as 10%

Hi
If you just want to replace your 10% with 10:1 (and 24% with 24:1) then you
can alter your formula and use a custom format.
If your total is in A2 and your 'score' is in B2, in C2 use
=(B2/A2)*100
and create a custom format of
#quot;:1quot;
The result in the cell will still be 10 but will display as 10:1

Hope this helps.
Andy.

quot;Charles-Manchesterquot; gt; wrote in
message ...
gt; Is there a formula that will automatically work out two numbers as a
gt; ratio,
gt; i.e. I want a sheet with numbers of sales calls, visits, sales, etc and to
gt; automatically be able to see the no of calls to sales, calls to visits,
gt; etc -
gt; I want to express as, i.e. 10:1 rather than as 10%
=SUBSTITUTE(TEXT(A1/B1,quot;?/?quot;),quot;/quot;,quot;:quot;)

--
Kind regards,

Niek Otten

quot;Charles-Manchesterquot; gt; wrote in
message ...
gt; Is there a formula that will automatically work out two numbers as a
gt; ratio,
gt; i.e. I want a sheet with numbers of sales calls, visits, sales, etc and to
gt; automatically be able to see the no of calls to sales, calls to visits,
gt; etc -
gt; I want to express as, i.e. 10:1 rather than as 10%
Perfect -thanks Niek

Charles

quot;Niek Ottenquot; wrote:

gt; =SUBSTITUTE(TEXT(A1/B1,quot;?/?quot;),quot;/quot;,quot;:quot;)
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Charles-Manchesterquot; gt; wrote in
gt; message ...
gt; gt; Is there a formula that will automatically work out two numbers as a
gt; gt; ratio,
gt; gt; i.e. I want a sheet with numbers of sales calls, visits, sales, etc and to
gt; gt; automatically be able to see the no of calls to sales, calls to visits,
gt; gt; etc -
gt; gt; I want to express as, i.e. 10:1 rather than as 10%
gt;
gt;
gt;