**Question description:**

*This user has given permission to use the problem statement for this blog.*

IF D3 = $20.00 to $49.99 then subtract said $ amount and move to D6 end if ? but I want 4 parameters 20.00-49.99 and 50.00 to 299.99 and 300.00 to 2499.00 and 2500.00 plus end if

Solved by V. Q. in 30 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
19/03/2018 - 11:17

2013

Excelchat Expert
19/03/2018 - 11:17

Greetings!

User
19/03/2018 - 11:17

hello

Excelchat Expert
19/03/2018 - 11:17

My name is Andrii, I'm here to help you

Excelchat Expert
19/03/2018 - 11:18

Could you explain in details what do you want to achieve?

User
19/03/2018 - 11:20

if c7 equalls more than $20 but less than $49.99 then I want to pull said money and drop down to c10 cell

User
19/03/2018 - 11:21

? but I want 4 parameters 20.00-49.99 and 50.00 to 299.99 and 300.00 to 2499.00 and 2500.00 plus

Excelchat Expert
19/03/2018 - 11:21

But what will be the result in each situation?

Excelchat Expert
19/03/2018 - 11:22

So you described what to do if sum is between 20 and 49

Excelchat Expert
19/03/2018 - 11:22

What to do between 50 and 299?

User
19/03/2018 - 11:23

if eWallet cell block is more than $20 and less than $50 then a new $20 contract would be bought (added to c10) same with 50-300 and 2500 plus

User
19/03/2018 - 11:23

contracts (cryptoMining) are $20 or $50 or $300 and a mining rigg is $2500, which is why i want those paramaters

Excelchat Expert
19/03/2018 - 11:24

Can you fill the green cells from D3?

Excelchat Expert
19/03/2018 - 11:25

I want to clarify what you expect to see in this situations

Excelchat Expert
19/03/2018 - 11:25

and in few minutes I will able to provide you with a solution

User
19/03/2018 - 11:26

c11 isnt' addiing the total of c8-10 yet. i didn't added c10 to the equation yet

Excelchat Expert
19/03/2018 - 11:27

Look, you want to have formula for C10 cell, right?

Excelchat Expert
19/03/2018 - 11:27

The result should depend on the value of C7

Excelchat Expert
19/03/2018 - 11:27

And you want to cover 4 situations

User
19/03/2018 - 11:27

yes

Excelchat Expert
19/03/2018 - 11:27

I displayed these 4 situations In C1:G3

User
19/03/2018 - 11:27

yes

Excelchat Expert
19/03/2018 - 11:27

Can you fill the green cells, so I could understand what you want to see in each case

Excelchat Expert
19/03/2018 - 11:28

So you have eWallet equals 30, what result should formula return?

User
19/03/2018 - 11:29

can we fix c11 first, to add c7:c10

Excelchat Expert
19/03/2018 - 11:29

U sure that C7:C10?

Excelchat Expert
19/03/2018 - 11:29

I did it

User
19/03/2018 - 11:30

okay perfect. So if c7 is between 20-49 then that 20 would drop to c10 and the balance would stay in c7

Excelchat Expert
19/03/2018 - 11:30

Okay, what about range 50-299?

User
19/03/2018 - 11:30

so if I have 35 dollars in my eWallet I am going to buy another 20 contract so 15 will stay in eWallet

Excelchat Expert
19/03/2018 - 11:31

So green result will be?

Excelchat Expert
19/03/2018 - 11:31

30-20?

Excelchat Expert
19/03/2018 - 11:31

or 20?

User
19/03/2018 - 11:31

between 50-299 then I would buy 50 contracts and remaining balance would be in eWallet

Excelchat Expert
19/03/2018 - 11:33

So green cells show the result that you expect to see?

Excelchat Expert
19/03/2018 - 11:33

Which are based on eWallet value?

User
19/03/2018 - 11:34

D4 F4 AND G4 YES

Excelchat Expert
19/03/2018 - 11:34

What about E3?

User
19/03/2018 - 11:34

E4 I'm not sure

Excelchat Expert
19/03/2018 - 11:34

Well, you may change it later

User
19/03/2018 - 11:34

Yes

Excelchat Expert
19/03/2018 - 11:34

Let it be 50 for now

User
19/03/2018 - 11:35

okay

Excelchat Expert
19/03/2018 - 11:35

Or I can just link it to this table if you like

Excelchat Expert
19/03/2018 - 11:35

so you will able to set settings from it

Excelchat Expert
19/03/2018 - 11:36

Okay, I got your problem, I will make the result in C10 based on what you asked

User
19/03/2018 - 11:36

perfect

User
19/03/2018 - 11:39

is that it? is that the formula I need

Excelchat Expert
19/03/2018 - 11:39

wait a minute please

Excelchat Expert
19/03/2018 - 11:40

Yes, that is it, it works

Excelchat Expert
19/03/2018 - 11:40

I formatted it so it would be easy for you to change any numbers later

User
19/03/2018 - 11:40

so it adds the 20 to c10 but it doesnt' take the 20 out of c7 (eWallet)

Excelchat Expert
19/03/2018 - 11:41

It can't do that, because it is calculated based on C7

Excelchat Expert
19/03/2018 - 11:41

We can calculate the new value of eWallet

Excelchat Expert
19/03/2018 - 11:41

and make sum counting only new value of eWallet

Excelchat Expert
19/03/2018 - 11:43

Is it good for you?

User
19/03/2018 - 11:44

yes now how can I get that code? just copy the cells

Excelchat Expert
19/03/2018 - 11:45

Press file and download it to your pc

Excelchat Expert
19/03/2018 - 11:45

Save as - xlsx

User
19/03/2018 - 11:46

Awesome thank you so much

Excelchat Expert
19/03/2018 - 11:46

You welcome!

Excelchat Expert
19/03/2018 - 11:46

Have a great day!

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