Sep 26 2019 03:54 PM
Hi,
G2 is the result from doing by hand: D2(times 3)+E2/D2(times 3) +E2+F2(times 3)+E2
I am wondering if that formula can be applied to the rest of the G columns, with their respective numbers?
Thank you
Sep 26 2019 05:44 PM
Sep 26 2019 06:15 PM
What you calculated by hand can be written as...
In G2
=(D2*3+E2)/((D2*3+E2)+(F2*3+E2))
Format G2 as percentage with two decimal points and then copy it down.