I there a good way to build a check for a % group of numbers

[Jeremy Clarkson]

Is there a way to build a check for a group of numbers that show growth. The spreadsheet I am working with is as similar to what is outlined below. Is there a mathematical or excel way for the sheet to check against itself to make sure that the growth column calculation is correct for each of the lines items and for the totals?

	2021​	2022​		Growth
A	100​	200​		100.0%​
B	200​	400​		100.0%​
				200.0%​

 

[etaf]

do you have a formula in the growth column ????
or did you just want a percent formula which checks

=(2022 cell - 2021 cell ) / 2021 cell

=(200-100) /100
=100/100
=1
=100%

so you could use that in another column - or conditional formatting

i suppose there maybe some fraction thats different
if someone has rounded up say
99.6% and made it 100%
then the calc would make it 99.6% and so flag as an error when its NOT
so may have to factor a tolerance

not sure on the 200% - why is that there - the total is not 200% but still 100%

300 600
=(600-300)/300

Book4
	A	B	C	D	E	F	G
1		2022		Growth
2	2021
3	A	100	200		100.0%		1
4	B	200	400		100.0%		1
5					200.0%
6
7
8		300	600				1
Sheet1

Cell Formulas
Range	Formula
G3:G4,G8	G3	=(C3-B3)/B3
B8:C8	B8	=SUM(B3:B7)

 

[Jeremy Clarkson]

The 200 is meaningless in terms of measure. What I am really trying to do is figure out if there is a formula to validate the totals against the individual values. in other words some combination to validate that 300 (2021) and 600 (2022) equal a total value of the percentage to ensure that all growth formulas are calculating correctly. I thought of using averages of each but that does column to get to an average percentage but that does not work.

 

[etaf]

i thought i provided that

some combination to validate that 300 (2021) and 600 (2022) equal a total value of the percentage to ensure that all growth formulas are calculating correctly.

when i said

=(2022 cell - 2021 cell ) / 2021 cell

=(200-100) /100
=100/100
=1
=100%

so you could use that in another column - or conditional formatting

and gave the above example

i clearly missed something and not understanding - sorry

validate that 300 (2021) and 600 (2022) equal a total value of the percentage

so use the formula in G8 i posted