So I have the five figures
A1 = 149
A2 = 46
A3 = 23
A4 = 13
A5 = 16
I want to add A2 + A3 = (69)
I then want to multiply that result by 3 = (207)
that is added to A4 + A5 = 236
Divide that by A1 = 1.583892617449664
The result shown as a percentage of 3 = 52.79%
I can do that in parts
Part 1 =SUM(A2+A3)*3+A4+A5 (Result 236)
Part 2 =the above result divided by A1
Part 3 the above divided by 3 to give a percentage.
but how do I construct this into just one formula please? I've tried, can't get it to give me the correct result.
Many thanks.
A1 = 149
A2 = 46
A3 = 23
A4 = 13
A5 = 16
I want to add A2 + A3 = (69)
I then want to multiply that result by 3 = (207)
that is added to A4 + A5 = 236
Divide that by A1 = 1.583892617449664
The result shown as a percentage of 3 = 52.79%
I can do that in parts
Part 1 =SUM(A2+A3)*3+A4+A5 (Result 236)
Part 2 =the above result divided by A1
Part 3 the above divided by 3 to give a percentage.
but how do I construct this into just one formula please? I've tried, can't get it to give me the correct result.
Many thanks.