Got something to say or just want fewer pesky ads? Join us... 😊

[Help] Excel gurus help please !



Garage_Doors

Originally the Swankers
Jun 28, 2008
11,789
Brighton
Excel gurus help please !



I have a total of £27935.78 and want to quote £8676.85 as a percentage.
I know it to be 31.06% and can do it by breaking it down into each part but that involves using several cells of information to do the one calculation
but how do I get excel to do it as a single formula please?

I want to quote it as follows:

So the row reads:
£27935.78.......................£8676.85...........................31.06%

thank you.
 




Bozza

You can change this
Helpful Moderator
Jul 4, 2003
55,719
Back in Sussex
B1 / a1 * 100

Screen Shot 2017-11-05 at 23.13.02.png
 




clapham_gull

Legacy Fan
Aug 20, 2003
25,308
As a general point don't try and be clever writing vanity extra long formulas. There is nothing wrong breaking the formula down into bite sized chunks and someone else may have to untangle it later.

Also I prefer to see a percentage as a value between 0 and 1 and use formatting to express it as a percentage.


Sent from my LG-K520 using Tapatalk
 


Albion and Premier League latest from Sky Sports


Top
Link Here