**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.*