Can anyone help me please work out how I set up a formula to work out the following.
1st column total 22 % second column 12.8% and have the third column add the percentage together the fourth column whats left .
MacBook Air
Hi gc,
22& of what?
12.8% of what?
'what's left' from what?
Wu=ith some assumptions regarding answers to the questions:
Formulas:
B2: $A2×B$1
Fill right to cell C2
D2: A2−B2−C2
Assumptions:
All percentages are percentages of the original amount.
"What's left" is the original amount minus both percentage results.
Regards,
Barry
Working out percentages in numbers please
