Excel - Multiplication/Division Q

[Sundance_Kid]

Hi Folks,

I seem to be having a brain freeze but I can't for the life of me work out the correct formula.

Cell A1 = 60
Cell B1 = 2
Cell C1 = 2
Cell D1 = 2
Cell E1 = 5

I am trying to divide Cell A1 by the other numbers combined.

So I need to add the range of Cells from B1 to D1 to get 6 and multiply it by Cell E1 to get 30.

Then divide Cell A1 by the 30.

My formula was = A1/Sum(B1:D1)*E1

But instead of getting the correct answer of 2, I am getting 50.

What am I doing wrong?

Thanks

 

[hrayani]

Place brackets

=A1/(SUM(B1:D1)*E1)

 

[alansidman]

Deleted

 

[Yongle]

or ...
=A1/SUM(B1:D1)/E1

 

[Sundance_Kid]

Place brackets

=A1/(SUM(B1:D1)*E1)

Many thanks

 

[hrayani]

You are welcome