Excel - IF Function Problem - Expert Solution

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
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
Excelchat Expert 27/03/2018 - 12:44
are you still there?
Excelchat Expert 27/03/2018 - 12:44
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
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
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
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.

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.