I'm trying to use a formula to indicate a users status based on whether a cell has a value in it or not. This is the formula that I'm using, but the only result I'm getting is "Inactive"
The criteria for the "Active" results are satisfied within a few cells, but I'm still receiving "Inactive" even for those. Any help is greatly appreciated, thanks!
Please Login or Register to view this content.
Damian37
your " " - are looking for a Space and not clear
change to
=IF(AND(N2<>"",O2=""),"Active",IF(AND(N2="",O2=""),"Active",IF(AND(N2<>"",O2<>""),"Inactive","false")))
OR
=IF(OR( AND(N2<>"",O2=""), AND(N2="",O2="")) , "Active",IF(AND(N2<>"",O2<>""),"Inactive","false"))
Which actually can be simplied to
=IF(O2="" , "Active",IF(AND(N2<>"",O2<>""),"Inactive","false"))
AS N2 does not matter for Active
Last edited by etaf; 03-21-2016 at 10:41 AM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Take out the space character between your quotation marks and see if it works, like so:
=IF(AND(N2<>"",O2=""),"Active",IF(AND(N2="",O2=""),"Active",IF(AND(N2<>"",O2<>""),"Inactive","false")))
--------
*Edit
oops, must have been submitting a response at the same time as etaf. Is there any way to delete my post?
--------
Here's a simpler alternative with the same output:
=IF(O2="","Active",IF(N2<>"","Inactive","false"))
Last edited by eibi; 03-21-2016 at 10:44 AM.
Thanks for the response. That worked great. For some reason I thought having a space between the quotes meant an empty cell. Thanks again!Originally Posted by etaf
you are welcome
eibi has a simplified version
thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks