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
thanks
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
yes
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
=(D41/C41)*1
Excelchat Expert
03/09/2018 - 09:04
Please use this =IFERROR((D41/C41)*1,100%)
User
03/09/2018 - 09:05
perfect
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.