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
Hello
Excelchat Expert
18/02/2018 - 08:20
How may I help you today?
User
18/02/2018 - 08:20
OK....
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.
