I need a simple formula to display the ratio between 2 numbers (cells) in a
large spreadsheet. The ratio must display itself as "#:#" and be linked to a
summary worksheet within the same workbook.I will then link all 23 sheets of
information to the one summary sheet for at-a-glance comparrisons of each
department's use of tools provided to them. The 2 cells that are providing
the information for the ratio have large formulas in them. I want the cells
linked, but not directly linked to the formulas in the reference cells.

Hi Suz,

If I understand you correctly,
say the two cells you require to show are H6 and C34
the formula will be
=H6&":"&C34

If there is a division between these two cells to be expressed
as a ratio then you will need to supply more info.

HTH
Martin


"Suz" <(E-Mail Removed)> wrote in message
news:0675CCFC-6727-4BB8-8C9C-(E-Mail Removed)...
>I need a simple formula to display the ratio between 2 numbers (cells) in a
> large spreadsheet. The ratio must display itself as "#:#" and be linked to
> a
> summary worksheet within the same workbook.I will then link all 23 sheets
> of
> information to the one summary sheet for at-a-glance comparrisons of each
> department's use of tools provided to them. The 2 cells that are providing
> the information for the ratio have large formulas in them. I want the
> cells
> linked, but not directly linked to the formulas in the reference cells.

Thank you so much! That worked. =)

"MartinW" wrote:

> Hi Suz,
>
> If I understand you correctly,
> say the two cells you require to show are H6 and C34
> the formula will be
> =H6&":"&C34
>
> If there is a division between these two cells to be expressed
> as a ratio then you will need to supply more info.
>
> HTH
> Martin
>
>
> "Suz" <(E-Mail Removed)> wrote in message
> news:0675CCFC-6727-4BB8-8C9C-(E-Mail Removed)...
> >I need a simple formula to display the ratio between 2 numbers (cells) in a
> > large spreadsheet. The ratio must display itself as "#:#" and be linked to
> > a
> > summary worksheet within the same workbook.I will then link all 23 sheets
> > of
> > information to the one summary sheet for at-a-glance comparrisons of each
> > department's use of tools provided to them. The 2 cells that are providing
> > the information for the ratio have large formulas in them. I want the
> > cells
> > linked, but not directly linked to the formulas in the reference cells.
>
>
>

Glad I could help.


"Suz" <(E-Mail Removed)> wrote in message
news:14B09D5B-67CA-4553-B34F-(E-Mail Removed)...
> Thank you so much! That worked. =)
>
> "MartinW" wrote:
>
>> Hi Suz,
>>
>> If I understand you correctly,
>> say the two cells you require to show are H6 and C34
>> the formula will be
>> =H6&":"&C34
>>
>> If there is a division between these two cells to be expressed
>> as a ratio then you will need to supply more info.
>>
>> HTH
>> Martin
>>
>>
>> "Suz" <(E-Mail Removed)> wrote in message
>> news:0675CCFC-6727-4BB8-8C9C-(E-Mail Removed)...
>> >I need a simple formula to display the ratio between 2 numbers (cells)
>> >in a
>> > large spreadsheet. The ratio must display itself as "#:#" and be linked
>> > to
>> > a
>> > summary worksheet within the same workbook.I will then link all 23
>> > sheets
>> > of
>> > information to the one summary sheet for at-a-glance comparrisons of
>> > each
>> > department's use of tools provided to them. The 2 cells that are
>> > providing
>> > the information for the ratio have large formulas in them. I want the
>> > cells
>> > linked, but not directly linked to the formulas in the reference cells.
>>
>>
>>

Hi Suz!

I have the same problem. I need to show to display as 1:2. Did you figure
out how to do this???

"Suz" wrote:

> I need a simple formula to display the ratio between 2 numbers (cells) in a
> large spreadsheet. The ratio must display itself as "#:#" and be linked to a
> summary worksheet within the same workbook.I will then link all 23 sheets of
> information to the one summary sheet for at-a-glance comparrisons of each
> department's use of tools provided to them. The 2 cells that are providing
> the information for the ratio have large formulas in them. I want the cells
> linked, but not directly linked to the formulas in the reference cells.