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