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.