Jump to content
workinglikeadog

Microsoft Excel help

Recommended Posts

1 minute ago, skel said:

So, 78% of 215, then 82% of 67 etc etc.

Not sure if this is what you mean, but is it as simple as:

=(a1/100)*b1

where a1 is percentage figure for school 1 (eg 78%) and b1 is number at school (eg 215)

  • Like 1

Share this post


Link to post
Share on other sites
12 hours ago, skel said:

Hello......my six monthly check in.....

I am trying to gather together data for two sunsets of schools, 8 in one group and 9 in the other.  The senior leadership want baseline data for each group. 

Some data is simply just adding and divding, as I can access raw number. Some data sets are in percentages for that school.   Simple if it was just a single school. But one school may have 100 students, another 50.  Is there a formula to work backwards to go from a percentage to a number.  Once I have the raw numbers I can work out totals and graphs.

So, 78% of 215, then 82% of 67 etc etc.

 

 

Is there a question in there?

If you want 78% of 215 then simply multiply 215 by 78%.

Remember % is simply another way of expressing a fraction relative to 100. 78% = 78/100ths or 0.78

Share this post


Link to post
Share on other sites

How come they are able to freeform the data?  Really!! In this digital age they should be sent the pro forma and return it completed in standard format and content. 

Share this post


Link to post
Share on other sites

Waiting for the day our AI overloads at MS implement a feature where if you even start thinking of using the wrong datatype, evil clippy jumps out with a taser gun...

  • Like 1

Share this post


Link to post
Share on other sites
3 hours ago, XCOM! said:

Waiting for the day our AI overloads at MS implement a feature where if you even start thinking of using the wrong datatype, evil clippy jumps out with a taser gun...

And JavaScript moves to strict variable typing.... Oh that will be the day!

Share this post


Link to post
Share on other sites
15 minutes ago, monkie said:

And JavaScript moves to strict variable typing.... Oh that will be the day!

Dare I say it... TypeScript.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×