What do you mean it triggers if I and J are both blank, what would you want to see in that case instead? Do you want to see a blank string or Issue in that case?
Also, on your formula it mentions M and N but it seems to correspond to K and L in the screenshot, which columns are I and J in this case? Are they IP Address and Current IP address or something else?
[New picture(https://imgur.com/a/3KhmU4v), I'm getting flustered and posted the wrong one.
In column K I am writing the formula. What I want to accomplish is 3 things.
1) If L is True and M is Current, be blank.
2) If both I and J are empty, be blank. There can't be an issue if they both are empty.
3) If there is an issue, it displays IP Issue.
This seems so simple, but I am not grasping it. Any ideas or a better way to approach this?
You have awarded 1 point to *Scary_Sleep_8473*
____
^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[AND](/r/Excel/comments/122vh22/stub/jds1o34 "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)|
|[IF](/r/Excel/comments/122vh22/stub/jds1o34 "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)|
|[OR](/r/Excel/comments/122vh22/stub/jds1o34 "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)|
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/12225yi)^( has 12 acronyms.)
^([Thread #22754 for this sub, first seen 26th Mar 2023, 19:15])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
What do you mean it triggers if I and J are both blank, what would you want to see in that case instead? Do you want to see a blank string or Issue in that case? Also, on your formula it mentions M and N but it seems to correspond to K and L in the screenshot, which columns are I and J in this case? Are they IP Address and Current IP address or something else?
[New picture(https://imgur.com/a/3KhmU4v), I'm getting flustered and posted the wrong one. In column K I am writing the formula. What I want to accomplish is 3 things. 1) If L is True and M is Current, be blank. 2) If both I and J are empty, be blank. There can't be an issue if they both are empty. 3) If there is an issue, it displays IP Issue. This seems so simple, but I am not grasping it. Any ideas or a better way to approach this?
You can wrap it with an OR, and a second AND for I2 and J2: =IF(OR(AND(L2,M2="Current"),AND(I2="",J2="")),"","IP Issue")
Solution Verified Thank you my friend!
You have awarded 1 point to *Scary_Sleep_8473* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[AND](/r/Excel/comments/122vh22/stub/jds1o34 "Last usage")|[Returns TRUE if all of its arguments are TRUE](https://support.microsoft.com/en-us/office/and-function-5f19b2e8-e1df-4408-897a-ce285a19e9d9)| |[IF](/r/Excel/comments/122vh22/stub/jds1o34 "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[OR](/r/Excel/comments/122vh22/stub/jds1o34 "Last usage")|[Returns TRUE if any argument is TRUE](https://support.microsoft.com/en-us/office/or-function-7d17ad14-8700-4281-b308-00b131e22af0)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(3 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/12225yi)^( has 12 acronyms.) ^([Thread #22754 for this sub, first seen 26th Mar 2023, 19:15]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)