excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · 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


 

Excel tip:

Convert Text into Number

Some 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

To convert Text into Number just encase the relevant cell reference or formula in the TEXT function. See Converting American Date to European hint

eg TEXT(Ref) or TEXT(formula)

View all Excel hints and tips


Server loaded in 0.09 secs.