Question description:
This user has given permission to use the problem statement for this
blog.
Excel Question
1. If one cell enters a number between 0 and 9, I would like to have the next cell populate with the default price of $2.90.......
2. If data is entered into a cell A between 10 and 15 I would like to have the next cell populate with the answer from the equation (Sum of Cell A * .15)
Solved by X. A. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/03/2018 - 08:48
welcome to excel got it pro.
Excelchat Expert
02/03/2018 - 08:48
I'm here to help you today.
User
02/03/2018 - 08:48
I am so going to use this all the time
Excelchat Expert
02/03/2018 - 08:49
Thanks. I do understand the first question. but I need your explanation on the 2nd. Would you please explain it a bit more?
User
02/03/2018 - 08:51
So if cell A is set up as a range so that cell B automatically enters the answer from the equation listed. I am entering a number of miles in one cell and that number dictates the price
User
02/03/2018 - 08:51
Miles multiplied by .15 cents gives me the haul rate
Excelchat Expert
02/03/2018 - 08:52
Okay, do you think you can picture it in the preview sheet? that would be a massive help.
User
02/03/2018 - 08:54
if B6 is a number ranging from 0 to 9 then C6 will automatically fill with $2.90
Excelchat Expert
02/03/2018 - 08:54
okay, and what are other ranges?
User
02/03/2018 - 08:55
If B6 is 27 then C6 then it will populate with the answer from 26*.15=C6
Excelchat Expert
02/03/2018 - 08:56
So, basically everything greater than 9 is that value multiplied by .15, right?
User
02/03/2018 - 08:56
yes
Excelchat Expert
02/03/2018 - 08:56
Thanks. I need a couple of minutes to write the formula.
Excelchat Expert
02/03/2018 - 08:58
=IF(AND(B6<>"",B6>9),B6*0.15,2.9) this is the appropriate formula.
Excelchat Expert
02/03/2018 - 08:58
Please input numbers in B9 to check and let me know.
Excelchat Expert
02/03/2018 - 08:59
A friendly reminder, I would love you to rate my service. You will be asked to rate me once you close the session by clicking on the end session button.
User
02/03/2018 - 09:00
wow!!!! where do I do the rating
Excelchat Expert
02/03/2018 - 09:00
You see the red end session button on top?
Excelchat Expert
02/03/2018 - 09:01
clicking on it will close the session and then you will be asked to rate me.
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.