How do I calculate ratios between 2 cells?

G

Guest

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
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMPRODUCT QUESTION?, Ratios 3
How do I display comparitive ratios such as "16:2"? 4
How do I Calculate a percentage 4
Automating skipping rows between selected cells. Please Help 3
how do I set up a simple subtraction between two cells 1
How do I calculate how many instances of a number appear in a wksh 3
Help with formula - return Qty from one cell if 2 conditions are m 1
how do i count cells with values in a certain range ? 3

Top