formula figure previous

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formula 50% of figure in previous column? | Excel forum

Formula 50% of figure in previous column? | Excel forum

resolvedResolved · Low Priority · Version 365

Sheila has attended:
Excel Introduction course

Formula 50% of figure in previous column?

What formula or sum do I use to find 50% of figure in previous column?

RE: formula 50% of figure in previous column?

Hi Sheila,

Thank you for the forum question.

If you have the figure in A2 then it is =A2*50% or =A2/2

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:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips


Server loaded in 0.08 secs.