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.