Calculate 100 % between two numbers

[Amor_S]

I have a small task that I can't get to calculate correctly.

In cell A1 is a number illustrating a 80% range of A2 and A2 should be 100 % and A3 i 120 % of A2. So A1 is 20% less then A2 and A3 i 20 % more.

A1 and A3 are given. To find the A2 value i calculated like this =(A1+A3)/2 . But when I take the A1 and 20 % it don't give the A2 number and also when adding 20 % to A2 don't give A3. This is probably my lack of basic math that I have forgotten.

Also I need to display a number in % in cell A5 showing the range from 80-120% of the number in cell A4.

 

[Joe4]

If you want to get the value in cell A2 just from using cells A1 and B1, the formula to put in cell A2 should look like:

=A1/B1

Also I need to display a number in % in cell A5 showing the range from 80-120% of the number in cell A4.

If I am understanding you correctly, place this formula in cell A5 and format the cell as a percent.

=1+(A4-A2)/A2

 

[Amor_S]

If you want to get the value in cell A2 just from using cells A1 and B1, the formula to put in cell A2 should look like:

=A1/B1

If I am understanding you correctly, place this formula in cell A5 and format the cell as a percent.

=1+(A4-A2)/A2

Thanks.
It worked with the percentages in A5. But not getting the correct amount in cell A2. The diff is 416. When compering A1 calculation for A2 and A3 calculation for A2.

 

[Joe4]

If I put the formula:

=A1/B1

in cell A2, I get the value: 641.25 (yours is very close, it shows 641.50).

So I guess I do not understand what the issue is...
Maybe you can take your example and walk us through your expected result and how you get there.

 

[Cubist]

Is this what you're looking for? Note the numbers are slightly off because the values in A1 and A3 are rounded.

Book1
	A	B	C	D
1	513,000	80%	513,200
2	641,500	100%
3	770,000	120%	769,800
4	700,000
5			109%
6
Sheet10

Cell Formulas
Range	Formula
C1	C1	=A2*B1
C3	C3	=A2*B3
C5	C5	=A4/A2

 

[Amor_S]

If I put the formula:

=A1/B1

in cell A2, I get the value: 641.25 (yours is very close, it shows 641.50).

So I guess I do not understand what the issue is...
Maybe you can take your example and walk us through your expected result and how you get there.

I also get 641.250 for A1/B1. But when I take A3/B3 the number is 641.666. Should the calculation give same value for If cell A2 is 100%?

 

[Joe4]

I also get 641.250 for A1/B1. But when I take A3/B3 the number is 641.666. Should the calculation give same value for If cell A2 is 100%?

Due to rounding. Your values are not exactly 80%/120%.