Spreadsheet help

Pie123

I want t work out what these tests change in percentage. 1 is in January another in MArch. How can i on a spreadsheet work out what the percentage growth or negative is please
Test 1 Test 2 Percentage change
1000 1270
2000 1234

Lyger

Hi Pie123,

Percentage is always calculated by (Given Amount divided by Total Amount) multiplied by 100.

Given that your test1 column is column A (total amount), and test2 is column B (Given amount), you'd need to type into cell C2 (your target cell) the following:

=(B2/A2)*100

Which would calculate:
=(1270/1000)*100 = 127

For row 2, this would give you a percentage value of 127%, showing a 27% growth from your original 1000. For row 3, this would give you 61.7%, showing a negative growth of 38.3%. To get the percentage growth value only, you could type the following into your target cell:

=100-((B2/A2)*100)*-1

Which would calculate:
=100-((1270/1000)*100)*-1 = 27

Hope that helps!

Banacek

I googled 'spreadsheet sum for percentage change between two cells' and it brought up loads of suggested ways to do it including step by step walk throughs.
Hope that helps.

bluboy

Lyger wrote: »

To get the percentage growth value only, you could type the following into your target cell:

=100-((B2/A2)*100)*-1

Which would calculate:
=100-((1270/1000)*100)*-1 = 27

I think you need another set of brackets to do it that way -

=(100-((B2/A2)*100))*-1

or alternatively
=(B2/(A2/100))-100

Percy1983

You could use:

=B2/A2-1

Then format the cells as percentage.

john_s_2

Percy1983 wrote: »

You could use:

=B2/A2-1

Then format the cells as percentage.

I second that. "Per cent" is French for "per 100" (or something like that). A percentage is a shorthand way of writing a fraction of something over 100.

So a fraction of 53/100 is the same as 53%

It is much easier to work with percentages in Excel if you hold the values as their 'true' values and format the cell to percentage.

So 50% would be held as 0.5, and 100% would be held as 1, etc.

Meepster

john_s wrote: »

I second that. "Per cent" is French for "per 100" (or something like that)

Hate to be picky, but you were nearly right, it's from the Latin 'per centum' meaning by the hundred.

Just hope percents origin comes up in the next pub quiz...

Lyger

bluboy wrote: »

I think you need another set of brackets to do it that way -

=(100-((B2/A2)*100))*-1

or alternatively
=(B2/(A2/100))-100

Ooops! You're right.

john_s_2

mwilletts wrote: »

Hate to be picky, but you were nearly right, it's from the Latin 'per centum' meaning by the hundred.

Cheers for that! I knew it was sumfink foreign ;-)