Can someone please assist with an IF statement?
I have 2 separate IF statements I would like to combine into a cell:
=IF(J4>0,"CIRCULATE","")
=IF(K4>0, "DRILL","")
So basically I want cell L4 to remain empty unless J4>0 which then i would want it to read "CIRCULATE" and if K4>0 then i would want cell L4 to read "DRILL"
Cells J4 and K4 will never have values greater than 0 simultaneously.
Thanks for any assistance.
Last edited by 6StringJazzer; 06-09-2018 at 08:59 AM. Reason: Moved from Hello..Introduce yourself
Try this:
Formula:
Please Login or Register to view this content.
That works for the > than values but I need that cell to be empty when no data is entered.. It is defaulting to "DRILL" when all cells are null
What do you mean "when all cells are null"? The behavior I see in my test is that
J4 > 0, result is CIRCULATE (regardless of what is in K4)
J4 is empty or <=0, and K4>0, result is DRILL
All other combinations, including empty cells, give a blank result.
Attach your file for testing. The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
Due to file sharing securities at my company, I am unable to share the actual file.
2018-06-09_9-23-41.png
2018-06-09_10-05-29.png
Last edited by rledoux06; 06-09-2018 at 11:06 AM.
You are showing that column L has Data Validation with a dropdown list. What is your validation rule? Data validation with a list doesn't play nicely when you put a formula into the cell. It is intended to validate manual data entry.
I removed the data validation all together to see if it would work and it still displays "Drill" when nothing else is entered...
=if(j4>0,"circulate","") & if(k4>0, "drill","")
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks everyone for your help, but this one: =if(j4>0,"circulate","") & if(k4>0, "drill","") is still defaulting it to "drill" even though other the criteria required is not met.
I attempted these above formulas in a blank sheet and its working.. I believe it is something in one of the cells.. I will attempt to find the bug.. Again thanks for all of your help!
If J4=1 and K4=1, you will get "CIRCULATEDRILL" which I suspect is not what is wanted.Originally Posted by mehmetcik
What is in J4 and K4? If these are formulas, perhaps the answer is there--can you share the formulas?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks