| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing cell by sum of two other cells
I have three columns of figures, i.e.:
A B C 8.53 1 47.83 I need a formula to divide 47.83 by the sum of 8.53 + 1. Can I do that without entering another column that shows the total of A & B. thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing cell by sum of two other cells
=C1/(A1+B1)
A1+B1 is in brackets because the addition needs to done before the division, Regards, Alan. "Randi" wrote in message ... I have three columns of figures, i.e.: A B C 8.53 1 47.83 I need a formula to divide 47.83 by the sum of 8.53 + 1. Can I do that without entering another column that shows the total of A & B. thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dividing cell by sum of two other cells
Thanks so much1
"Alan" wrote: =C1/(A1+B1) A1+B1 is in brackets because the addition needs to done before the division, Regards, Alan. "Randi" wrote in message ... I have three columns of figures, i.e.: A B C 8.53 1 47.83 I need a formula to divide 47.83 by the sum of 8.53 + 1. Can I do that without entering another column that shows the total of A & B. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging a row & dividing by only the qty. of cells with a value | Excel Discussion (Misc queries) | |||
| Need help w/ adding cells and dividing SUM by number of cells | Excel Worksheet Functions | |||
| Dividing cells by 1000 | Excel Discussion (Misc queries) | |||
| Dividing linked cells | Excel Worksheet Functions | |||
| Dividing up cells | Excel Discussion (Misc queries) | |||
Linear Mode
