Someone has asked me to help solve a problem and I am not certain it's possible....I'm looking for some help
E equals the weighted sum of 4 numbers, A B C D but with each number having an assigned value. I will always know what A B C & D are and need E
E is made up of 4 parts
15% of E = A
25% of E = B
35% of E = C
25% of E = D
He's looking for a formula to use in excel so he can plug in A B C & D to find E
We are both getting lost...any ideas?
For example, if:
B = 30
What is E?
Not sure if this makes sense...
Is that possible since B & D are same weight of the total but different numbers...
Any help/direction is appreciated!