Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel

ResolvedVersion 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

Excel tip:

Recovering Unsaved Work in Excel 2010

Ever closed your Excel workbook in a hurry without saving your work beforehand? Here's how to get it back.

Choose File then Info, click Manage Versions and then Recover Unsaved Workbooks which will automatically find the spreadsheets that haven't been saved.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.