creating percentages

AI Training: For Busy Decision Makers & Professionals Book now

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

Creating percentages

resolvedResolved · Medium Priority · Version 2010

Gavin has attended:
Excel Intermediate course

Creating percentages

i am trying to create a sum with the result as a percentage, please could you help?

Edited on Tue 12 May 2020, 18:12

RE: creating percentages

Hi Gavin,

Thank you for the forum question.

I need more details please.

A percentage of what.

Do you have a column with values and want for each value to have a percentage of the column total?

Or do you have a total of expenses and want to calculate the expenses percentage of the income?

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector


 

Excel tip:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Server loaded in 0.13 secs.