Hello,

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:

A= 4

B = 30

C= 25

D= 60

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!