Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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
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
