98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version Standard
Kylie has attended:
Excel Intermediate course
Excel
How do you do percentage formula's using a range of data?
RE: Excel
Hiya Kylie
Hope you are well and you enjopyed the course on Tuesday
as for the answer that will depend on if you want to calculate a data range by a percent if that is the case then here is a formula that will do that for you
=sum(b4:g20)+15%
=sum(b4:g20)*1.7%
=average(d4,e5,h10,a4,f2)*17.5%
Now Kylie the above formulas are just working examples apply them to you own data
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert Text into NumberSome times numbers maybe imported in as text or you maybe concatenating numbers that form a text string that now are treated, because you had to extract them by Text functions |