Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

excel if x>=Y then display Y if x<= Y then display X or 0
Solved by K. U. in 18 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/02/2018 - 08:19
Welcome, Thanks for choosing Got It Pro-Excel
User 18/02/2018 - 08:20
Excelchat Expert 18/02/2018 - 08:20
How may I help you today?
User 18/02/2018 - 08:20
Excelchat Expert 18/02/2018 - 08:21
Please let me know your query
User 18/02/2018 - 08:22
If Cell e2 is equal to or greater than A12, display a12. If cell e2 is equal to or less than A12 then display 0
Excelchat Expert 18/02/2018 - 08:22
Alright, please give a moment to solve your problem. Thank you!
User 18/02/2018 - 08:22
I think it's an OR statement but can't quite figure it out
User 18/02/2018 - 08:22
ok, thank you
Excelchat Expert 18/02/2018 - 08:24
Please check formula on cell B12
User 18/02/2018 - 08:25
I expressed it wrong. Let me try again
Excelchat Expert 18/02/2018 - 08:26
No problem
User 18/02/2018 - 08:28
If A12 is equal to or greater than C2, then display A12. If is equal to or less than C2, display C2 or 0.
Excelchat Expert 18/02/2018 - 08:28
One moment please
Excelchat Expert 18/02/2018 - 08:29
Please check
User 18/02/2018 - 08:31
no. My fault. I'm failing to express it properly. Sorry
Excelchat Expert 18/02/2018 - 08:32
No problem. Once you are sure about your question you can re-post your question anytime
User 18/02/2018 - 08:34
If C2 is equal to or greater than A12, then display A12. If C2 is equal or less than A12, then display C2 or 0
User 18/02/2018 - 08:35
That last bit... the "or 0" part, may need thought out more
User 18/02/2018 - 08:35
I know what I want it to do, but I'm not sure if I am expressing it properly
Excelchat Expert 18/02/2018 - 08:36
Please check now on cell B2
User 18/02/2018 - 08:36
So in your example, B15 should read 900. B16 0 and B17 0
Excelchat Expert 18/02/2018 - 08:36
One moment
Excelchat Expert 18/02/2018 - 08:37
Done now
User 18/02/2018 - 08:38
ok, I will try that. Thank you. Bye for now
Excelchat Expert 18/02/2018 - 08:38
If you have any more issues, please don’t hesitate to let us know. 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.

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc