# Excel - IF Function Problem - Expert Solution

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

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.