Excel - IF Function Problem - Expert Solution

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

I am sure I am making it harder than it is. I want cell F12 to have the result of YES or NO based on cell E12 If E12 is less than zero (negative amount) then F12 should be NO If E12 is greater than zero (positive amount) then F12 should be YES OR If E12 is red then F12 should be NO iF E12 is green then F12 should be YES
Solved by T. J. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 06/10/2017 - 04:27
Hello, I understand that you want the value of F12 to be YES/NO depending on the value of your E12, right?
User 06/10/2017 - 04:27
User 06/10/2017 - 04:27
I tried to attach my worksheet, but can't convert to an extension your site would accept
Excelchat Expert 06/10/2017 - 04:27
Okay, I just need to clarify the last part of your request, you mentioned colors in there. Are these text or are they the color of the cells?
User 06/10/2017 - 04:28
I am willing to do either
Excelchat Expert 06/10/2017 - 04:28
I asked because Excel's built-in formulas cannot detect the cell's color. Only VBA/Macro can do that. If they are text then we can create the formulas for you.
User 06/10/2017 - 04:28
I prefer to fdo it the route of the first way, but am willing to try just about anything
Excelchat Expert 06/10/2017 - 04:29
Okay, in order to be able to accurately give you the solution, can you give me example data using the Document Preview to the right?
User 06/10/2017 - 04:30
this is my exact worksheet pasted in
Excelchat Expert 06/10/2017 - 04:30
This is awesome! Thank you for a very detailed example. :)
Excelchat Expert 06/10/2017 - 04:30
What will the result be if E12 is exactly 0?
User 06/10/2017 - 04:31
that would be a one in a million, but if E12 equals 0 or is greater than zero it will be YES
Excelchat Expert 06/10/2017 - 04:32
If that's the case then please see the formula in F12.
User 06/10/2017 - 04:32
if less than zero the result is NO
Excelchat Expert 06/10/2017 - 04:32
You may change the value of E12 to test it.
Excelchat Expert 06/10/2017 - 04:32
Try to play with the value in E12 to test it out.
User 06/10/2017 - 04:33
Excelchat Expert 06/10/2017 - 04:33
User 06/10/2017 - 04:33
I just pasted it to my workbook I have saved, tweaked numbers and it WORKED!!!!!
Excelchat Expert 06/10/2017 - 04:33
Thank you for your patience in explaining it to me.
Excelchat Expert 06/10/2017 - 04:33
Would there be anything else that I can help you with regards to the original question?
User 06/10/2017 - 04:33
after 2 hours of playing with formulas I thought it was a lost cause
User 06/10/2017 - 04:33
no sir. THank you VERY much!
Excelchat Expert 06/10/2017 - 04:33
I'd appreciate a 5-star rating if you think I deserve it. :)
Excelchat Expert 06/10/2017 - 04:34
Please do not forget to click the End Session otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.
User 06/10/2017 - 04:34

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