How do I calculate ratios between 2 cells?

Hi,

I need to work out a ratio between two figures (eg. the number of replies to
sales made etc). Both cells are in the same worksheet.

Sounds easy but I can't get anywhere with HELP. If anyone can help I'd very
much appreciate it.

Kind regards

How about = A1/B1? A1 has replies and B1 has sales
You could even format it % to get percent value.
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Excel Novice" <ExcelNovice@discussions.microsoft.com> wrote in message
news:CCCFFBBF-970D-456B-B28A-E46FD3CD76F6@microsoft.com...
> Hi,
>
> I need to work out a ratio between two figures (eg. the number of replies
> to
> sales made etc). Both cells are in the same worksheet.
>
> Sounds easy but I can't get anywhere with HELP. If anyone can help I'd
> very
> much appreciate it.
>
> Kind regards

Thanks Bernard - I did have a bit of a "Doh!" moment when I realised how to
do it and esentially how easy it was.

"Bernard Liengme" wrote:

> How about = A1/B1? A1 has replies and B1 has sales
> You could even format it % to get percent value.
> best wishes
>
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Excel Novice" <ExcelNovice@discussions.microsoft.com> wrote in message
> news:CCCFFBBF-970D-456B-B28A-E46FD3CD76F6@microsoft.com...
> > Hi,
> >
> > I need to work out a ratio between two figures (eg. the number of replies
> > to
> > sales made etc). Both cells are in the same worksheet.
> >
> > Sounds easy but I can't get anywhere with HELP. If anyone can help I'd
> > very
> > much appreciate it.
> >
> > Kind regards
>
>
>