Question description:
This user has given permission to use the problem statement for this
blog.
How to subtract $100 only if in a cell A1 has a 1 and subtract $200 if the cell has a 2 and 3 if 3 4 if 4 and so on
Solved by G. L. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
27/03/2018 - 12:38
yes
Excelchat Expert
27/03/2018 - 12:38
Hi
Excelchat Expert
27/03/2018 - 12:38
welcome to got it pro
User
27/03/2018 - 12:38
How to subtract $100 only if in a cell A1 has a 1 and subtract $200 if the cell has a 2 and 3 if 3 4 if 4 and so on
Excelchat Expert
27/03/2018 - 12:38
do you have an existing file?
User
27/03/2018 - 12:38
no
Excelchat Expert
27/03/2018 - 12:38
ok
Excelchat Expert
27/03/2018 - 12:38
so let us use the google sheet in the right side
User
27/03/2018 - 12:39
yes
Excelchat Expert
27/03/2018 - 12:39
i will put 1 in cell A1
Excelchat Expert
27/03/2018 - 12:39
1
User
27/03/2018 - 12:39
so let me tell you my q
Excelchat Expert
27/03/2018 - 12:39
ok
User
27/03/2018 - 12:40
so I'm earning lets say 500
Excelchat Expert
27/03/2018 - 12:40
ok
Excelchat Expert
27/03/2018 - 12:40
i can see you are putting some data
User
27/03/2018 - 12:41
yes
Excelchat Expert
27/03/2018 - 12:41
please continue
User
27/03/2018 - 12:41
lets say those are my ernining weekly
Excelchat Expert
27/03/2018 - 12:42
ok
Excelchat Expert
27/03/2018 - 12:42
please continue
Excelchat Expert
27/03/2018 - 12:44
are you still there?
Excelchat Expert
27/03/2018 - 12:44
please continue
User
27/03/2018 - 12:44
I wand to put away for saving £50 per a week
Excelchat Expert
27/03/2018 - 12:45
so i wlll subtract 50 to each earning?
User
27/03/2018 - 12:45
and want to see the remaining of my income
Excelchat Expert
27/03/2018 - 12:46
column D gives you the remaining income after subtracting saviings from earnings
Excelchat Expert
27/03/2018 - 12:46
does this answer your question?
User
27/03/2018 - 12:47
yes but some week I want to put a saving £100 and that was for two weeks but from one week wage
Excelchat Expert
27/03/2018 - 12:47
you can change 50 to 100?
User
27/03/2018 - 12:48
and I don't want to be putting in the amount I want to save
User
27/03/2018 - 12:49
i want to just tell excel 2 or 3 and he should if that 2*50 or 3*50
Excelchat Expert
27/03/2018 - 12:49
excel should know what to subtract
User
27/03/2018 - 12:49
yes
Excelchat Expert
27/03/2018 - 12:49
i change the formula in column D
Excelchat Expert
27/03/2018 - 12:50
now you can put 2 or 3 in column C
User
27/03/2018 - 12:50
so i tell subtract 2week for saving that 100
Excelchat Expert
27/03/2018 - 12:50
please try
User
27/03/2018 - 12:51
no i want some formula to do this
Excelchat Expert
27/03/2018 - 12:51
you mean subtract 100 from week 2 earning?
User
27/03/2018 - 12:51
mabe a if or sumif
User
27/03/2018 - 12:51
no from one week earning
Excelchat Expert
27/03/2018 - 12:52
so no need to put week number?
User
27/03/2018 - 12:52
now from that cell I'm in 2 week
User
27/03/2018 - 12:52
or 3
Excelchat Expert
27/03/2018 - 01:03
please see solution
Excelchat Expert
27/03/2018 - 01:03
thanks
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.
