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" wrote in message
...
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