what equation would i need to use to achieve the following:
I have 3 Columns(many rows), & I need column C to show the difference between the numbers in column A and B - BUT I need all the answers to be a %.
e.g
Sum of schoolsAllocated Sum of schoolsVisited difference schools visited and schools allocated as%
1846 1703
94 94
36 36
262 234
Any ideas would be much appreciated..
Try in C1 and copy down.
=(A1-B1)/A1
Format as %
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Works perfectly thanks very much
.........................
Hi,
You didn't actually mention whether the difference should be a % of column A or B. Just check that the result is relevant to your particular circumstances.
For instance:
=(A1-B1)/B1
will still give you a % but a different one of course.
Or your original post could be interpreted as simply wanting
=B1/A1
Only you can decide which is the one you want.
Last edited by Richard Buttrey; 03-15-2013 at 07:56 AM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Ok now i am confused - I need to use the same formula as a calculated field so I can use KPIs -. the formula =(A1-B1)/B1 works
What do you mean? What is KPIs ???Originally Posted by DAVEG01
Here you go Fotis1991
http://lmgtfy.com/?q=KPI
Regards Kevin
Merged Cells (They are the work of the devil!!!)
It's better for me, first try to learn Basic English and then i'll learn the KPI(Key performance indicator ??), Kevin UK
In excel 2013 you can use Key performance indicators - but you need a calculated field in order to do so.
As i told, my English does not let me understand. Also i don't have Excel 2013....
Perhaps if i(we) had a small sample workbook....
Or maybe someone else, can helps you..
Is that not something to do with power pivot!
Hi kevin - yes is is to do with Power Pivot.
Hi,
Don't concentrate on KPIs just at the moment. Tell us in narrative form what idea you are trying to express with your data.
For instance, with the two pieces of data
In A1 meaning Sum of All Schools: 1846
In B1 meaning Sum of Allocated Schools: 1703
If you want to know what percentage allocated schools are as a % of All schools, then the simple
=B1/A1
is the answer
If you want to know how many schools are NOT allocated then
=(A1-B1)/A1
as given by Fotis in his original post is the answer .
As I said in post #5 only you can decide what idea you are trying to express in an eventual KPI
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks