Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
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
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