How do I calculate ratios between 2 cells?

E

Excel Novice

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
 
B

Bernard Liengme

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

Excel Novice

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