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