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

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

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