| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIF cells are not empty | Excel Discussion (Misc queries) | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
