Excel - IF Function Problem - Expert Solution

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

i need a formla to say if a colum is above 0% then its Marked as "Target OFF"
Solved by A. A. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 03/09/2018 - 08:54
Welcome to got it pro.
Excelchat Expert 03/09/2018 - 08:54
We are delighted to have you here with us.
User 03/09/2018 - 08:54
Excelchat Expert 03/09/2018 - 08:55
So, Can you please show me some sample of your data?
User 03/09/2018 - 08:55
i cant show my data due to data protection but i hae a current formular that is =IF(D40<C40,"OFF","ON")
User 03/09/2018 - 08:55
but i need it to show OFF if above 0%
Excelchat Expert 03/09/2018 - 08:56
I understand if you can't show me your original data but I can work with what you have told me. So, it's alright.
Excelchat Expert 03/09/2018 - 08:56
I will show an example of what you need to do in the preview window.
Excelchat Expert 03/09/2018 - 08:57
Let's assume your data is in column A.
Excelchat Expert 03/09/2018 - 08:57
Are you able to see what I wrote in column A?
User 03/09/2018 - 08:58
Excelchat Expert 03/09/2018 - 08:58
=IF(A1>0,"YES","NO") This is the formula I wrote in column B.
Excelchat Expert 03/09/2018 - 08:59
Makes sense?
User 03/09/2018 - 08:59
yes just trying it now
Excelchat Expert 03/09/2018 - 08:59
The syntax Of IF function is =IF(logical-test,value-if-true,value-if-false)
Excelchat Expert 03/09/2018 - 09:01
So, In the above formula our logical test is A1>0, when this test is TRUE the formula will show "YES", otherwise "NO". Since you want to see "OFF" if the logical test is true, you need to write =IF(A1>0,"OFF","ON")
User 03/09/2018 - 09:02
thats work perfect thank you
User 03/09/2018 - 09:02
just another one for you
Excelchat Expert 03/09/2018 - 09:03
May I ask you for a favor? Please rate my service, your rating is essential for my earning flow.
User 03/09/2018 - 09:03
when a colum is showing zero because no data has been imputted its showing ~DIV/O!
User 03/09/2018 - 09:03
is there any way to get this to say 100%
Excelchat Expert 03/09/2018 - 09:04
Yeah, may I see the formula that is giving this DIV/0 error?
User 03/09/2018 - 09:04
Excelchat Expert 03/09/2018 - 09:04
Please use this =IFERROR((D41/C41)*1,100%)
User 03/09/2018 - 09:05
Excelchat Expert 03/09/2018 - 09:05
I'm glad to hear that.
Excelchat Expert 03/09/2018 - 09:06
Please rate my service after closing the chat.
User 03/09/2018 - 09:06
when my columns show on and off i have them coloured green and red. can this be inputted on the formula?
Excelchat Expert 03/09/2018 - 09:07
This is another problem right? I'm sorry to say that our company policy does allow me to answer more than one problem is a session. I hope you understand my situation.
Excelchat Expert 03/09/2018 - 09:08
If you need help on this new problem, you can close this chat and open a new session again.
User 03/09/2018 - 09:08
ok thanks
Excelchat Expert 03/09/2018 - 09:08
Thank you for understanding.
Excelchat Expert 03/09/2018 - 09:08
Anything else you need to know on the problem I have already helped you to solve?
User 03/09/2018 - 09:09
no all sorted
Excelchat Expert 03/09/2018 - 09:09
It's great to hear. Don't forget to visit us in future. Enjoy a great day ahead!
Excelchat Expert 03/09/2018 - 09:10
Also, please don't forget to rate my service, it would mean a lot to 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.

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