Find Rate automatically

[Diimo]

Hi,
I have spreadsheed and I need to find the appropriate rate (give n =0.02 when B1= 100) when the user inputs moretan 100 in cell B1.
I have attached sample numbers by using 200 as a new input - I found a new rate of 0.03 ( Cell E2) will give me the exact variation in in Cell E8.

My question is there way /formula to find the new Rate ( Cell E2) with any input value morethan 100 by keeping the current variation ( B8=E8) same by any number.

Thanks in adavance.

DM

New input	100​			New input	200​
Rate	0.02​	Cell B2		Rate	0.03​	Cell E2
(Total* Rate)	2​	b1*b2		(Total* Rate)	6​
deduct from Total	98​	B1-b3		deduct from Total	194​
Fixed cost	2​			Fixed cost	2​
New total - Fixed cosr	96​	b4-b5		New total - Fixed cosr	192​
Variation	1.041667​	Cell B8		Variation	1.041667​	Cell E8

 

[Deleted member 4993]

Hi,
I have spreadsheed and I need to find the appropriate rate (give n =0.02 when B1= 100) when the user inputs moretan 100 in cell B1.
I have attached sample numbers by using 200 as a new input - I found a new rate of 0.03 ( Cell E2) will give me the exact variation in in Cell E8.

My question is there way /formula to find the new Rate ( Cell E2) with any input value morethan 100 by keeping the current variation ( B8=E8) same by any number.

Thanks in adavance.

DM

New input	100​			New input	200​
Rate	​ 0.02​	Cell B2		Rate	0.03​	Cell E2
(Total* Rate)	2​	b1*b2		(Total* Rate)	6​
deduct from Total	98​	B1-b3		deduct from Total	194​
Fixed cost	2​			Fixed cost	2​
New total - Fixed cosr	96​	b4-b5		New total - Fixed cosr	192​
Variation	1.041667​	Cell B8		Variation	1.041667​	Cell E8

Yes - but you need to know what you know and possibly why you are stuck!

Please show us what you have tried and exactly where you are stuck.

Please follow the rules of posting in this forum, as enunciated at:

https://www.freemathhelp.com/forum/threads/read-before-posting.109846/#post-486520

Please share your work/thoughts about this assignment.

 

[HallsofIvy]

I think "moretan" was supposed to be "more than"! That puzzled me for a moment.
Also you talk about "total" but there is no "total" in the spreadsheet. I think what is labeled "input" should have been "total".

If I read this correctly you are asking "what should "Rate" be for a given "total" ("input") so that "variation" will remain equal to 1.041667. The problem is that there is no definition of "variation"! How is variation defined?