Excel - IF Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.