**Question description:**

*This user has given permission to use the problem statement for this blog.*

Trying to write a formula for the value in a cell would = $25,000 if the value in cell E4 was less than 1,000,000. If E4 is> 8,000,000 then = $200,000. If E4 is between 1,000,000 and 8,000,000 the cell is calculated as E4*0.025

Solved by K. F. in 40 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
18/09/2018 - 08:25

Welcome, Thanks for choosing Got It Pro-Excel. I can help you with that problem.

Excelchat Expert
18/09/2018 - 08:25

Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.

User
18/09/2018 - 08:25

ok thank you

Excelchat Expert
18/09/2018 - 08:25

Do you have sample data which we can use to illustrate how to solve this problem?

User
18/09/2018 - 08:26

no I don

Excelchat Expert
18/09/2018 - 08:26

Okay.

User
18/09/2018 - 08:26

I just need to understandhow to write that in a if then statement

Excelchat Expert
18/09/2018 - 08:26

Okay.

Excelchat Expert
18/09/2018 - 08:26

Based on what you’ve shared, you need an IF function to solve the problem.

User
18/09/2018 - 08:26

basically I gave you a sample of what I want to say

Excelchat Expert
18/09/2018 - 08:26

Do you believe that will address your problem?

User
18/09/2018 - 08:26

correct

User
18/09/2018 - 08:27

I just can't seem to figure out how

User
18/09/2018 - 08:27

yes I do

Excelchat Expert
18/09/2018 - 08:27

Okay. Let me formulate it, will get back to you shortly.

Excelchat Expert
18/09/2018 - 08:33

Thank you for your patience.

Excelchat Expert
18/09/2018 - 08:33

The function is:

Excelchat Expert
18/09/2018 - 08:33

=IF(E4<1000000,25000,IF(E4<8000000,E4*0.025,200000))

Excelchat Expert
18/09/2018 - 08:34

Kindly confirm that it works fine.

Excelchat Expert
18/09/2018 - 08:34

Does this solution solve your problem?

Excelchat Expert
18/09/2018 - 08:35

Are you there?

Excelchat Expert
18/09/2018 - 08:41

I did not receive responses from your end. You can always chat with us as we provide steps to solving your problem.

User
18/09/2018 - 08:41

yes thank you!

Excelchat Expert
18/09/2018 - 08:42

Has it worked fine?

Excelchat Expert
18/09/2018 - 08:43

Is there any questions or clarifications you may need in regards to this?

Excelchat Expert
18/09/2018 - 09:03

It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.

Excelchat Expert
18/09/2018 - 09:03

Please remember to rate us at the end of the chat for better and quality services. Thank you!

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