**Question description:**

*This user has given permission to use the problem statement for this blog.*

how to stop a formula, for example Cell A 1 * Cell B 1, for 12 months, B 1 = 10, after 6 months B 1 became 12 but if i put 12 in B 1 then the first 6 months calculation will not be at 10 but at 12, how can it automatically be converted and do not calculate it

Solved by G. U. in 12 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
03/08/2018 - 07:04

Hi
Welcome to Gotit pro. How can I help you?

User
03/08/2018 - 07:04

Hi

User
03/08/2018 - 07:05

i am looking for a solution

Excelchat Expert
03/08/2018 - 07:05

ok on which is it?

User
03/08/2018 - 07:06

hope you can see the excel sheet

Excelchat Expert
03/08/2018 - 07:06

yes im seeing on i

Excelchat Expert
03/08/2018 - 07:06

it*

User
03/08/2018 - 07:06

now if i change cell C 4 to 20%

User
03/08/2018 - 07:06

certain months value should not change

User
03/08/2018 - 07:06

for example lets say comission

User
03/08/2018 - 07:06

after sept the comission % is 20%

User
03/08/2018 - 07:07

here April to Aug it shoudl be at 10%

User
03/08/2018 - 07:07

and from Sept at 20%

Excelchat Expert
03/08/2018 - 07:07

ok, so it would be doubled?

Excelchat Expert
03/08/2018 - 07:07

is it like that?

User
03/08/2018 - 07:07

but April to aug shoudl only be 100

User
03/08/2018 - 07:08

yes

User
03/08/2018 - 07:08

is there a formula to freeze the amounts from April to Aug

User
03/08/2018 - 07:08

and not do manually

Excelchat Expert
03/08/2018 - 07:08

oh we dont have that function in excel

Excelchat Expert
03/08/2018 - 07:09

we can only fix that if we will remove the formula

User
03/08/2018 - 07:09

hmmmmmmm

User
03/08/2018 - 07:09

is there any other way

Excelchat Expert
03/08/2018 - 07:09

you want to fix apr - aug in 100?

User
03/08/2018 - 07:09

the objective is to make it automatic

User
03/08/2018 - 07:10

and no manual intervention

User
03/08/2018 - 07:10

yes

Excelchat Expert
03/08/2018 - 07:10

ok

Excelchat Expert
03/08/2018 - 07:10

so it the percent is 10%, you want apr-aug as 100

User
03/08/2018 - 07:11

C 4 is dynamic

User
03/08/2018 - 07:11

it keeps on changing

Excelchat Expert
03/08/2018 - 07:11

ok

User
03/08/2018 - 07:11

it can be 10% ,20% etc

User
03/08/2018 - 07:11

but once i calculate for one month

User
03/08/2018 - 07:11

that month amount should not change

Excelchat Expert
03/08/2018 - 07:12

so if any percent on C4

Excelchat Expert
03/08/2018 - 07:12

apri - aug would still be 100 and not changing?

User
03/08/2018 - 07:12

yes because the starting point is 10%

User
03/08/2018 - 07:12

from April to Aug

User
03/08/2018 - 07:13

after Aug its becomes 20% or 30%

User
03/08/2018 - 07:13

but that doesnt mean that April to Aug amounts will change

User
03/08/2018 - 07:13

it should still reamin 100

Excelchat Expert
03/08/2018 - 07:13

ok im getting your point

Excelchat Expert
03/08/2018 - 07:14

but excel doesn't have that function to fix the value, particularly if this has formula

User
03/08/2018 - 07:14

ok

Excelchat Expert
03/08/2018 - 07:14

want we can only do was a paste special

Excelchat Expert
03/08/2018 - 07:15

for apr - aug

User
03/08/2018 - 07:15

ok got it

User
03/08/2018 - 07:15

Thanks for your help

Excelchat Expert
03/08/2018 - 07:15

your welcome

Excelchat Expert
03/08/2018 - 07:15

Is there anything else I can help you with?

User
03/08/2018 - 07:15

i am good

Excelchat Expert
03/08/2018 - 07:15

ok cool :)

User
03/08/2018 - 07:15

and what are the fees if i have some more questions

Excelchat Expert
03/08/2018 - 07:16

im not sure for the fees, but likes monthly subscription

User
03/08/2018 - 07:17

ok

User
03/08/2018 - 07:17

thank you

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*