Excel - IF Function Problem - Expert Solution

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.

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.