Combining forumlas to get a desired output?

[2weetabix]

I hope someone can help as brain fog is stepping in my way of solving this one.

I'm trying to put some logic into a spreadsheet so it automatically prints a comment in the last cell (D) based on the combinatin of TRUE/FALSE values
Cells A to C are automatically populated with TRUE or FALSE values as show.
There are three possible combinations of values:

Comments greatly appreciated

 

[etaf]

what do you want if those 3 conditions do not exist

=AND( A2=TRUE,B2=TRUE,C2=TRUE) and a combination of those
=IF(AND(A2=TRUE,B2=TRUE,C2=TRUE),"Consider for removal",IF(AND(A2=FALSE,B2=FALSE,C2=FALSE),"User never logged on",IF(AND(A2=TRUE,B2=FALSE,C2=FALSE),"User has logged on - don't bother about reporting this one","")))A2=TRUE,B2=FALSE,C2=FALSE), "User has logged on - don't bother about reporting this one", "")))

Book4
	A	B	C	D
1
2	TRUE	TRUE	TRUE	Consider for removal
3	FALSE	FALSE	FALSE	User never logged on
4	TRUE	FALSE	FALSE	User has logged on - don't bother about reporting this one
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=IF(AND(A2=TRUE,B2=TRUE,C2=TRUE),"Consider for removal",IF(AND(A2=FALSE,B2=FALSE,C2=FALSE),"User never logged on",IF(AND(A2=TRUE,B2=FALSE,C2=FALSE),"User has logged on - don't bother about reporting this one","")))

 

[2weetabix]

what do you want if those 3 conditions do not exist

=AND( A2=TRUE,B2=TRUE,C2=TRUE) and a combination of those
=IF(AND(A2=TRUE,B2=TRUE,C2=TRUE),"Consider for removal",IF(AND(A2=FALSE,B2=FALSE,C2=FALSE),"User never logged on",IF(AND(A2=TRUE,B2=FALSE,C2=FALSE),"User has logged on - don't bother about reporting this one","")))A2=TRUE,B2=FALSE,C2=FALSE), "User has logged on - don't bother about reporting this one", "")))

Book4
	A	B	C	D
1
2	TRUE	TRUE	TRUE	Consider for removal
3	FALSE	FALSE	FALSE	User never logged on
4	TRUE	FALSE	FALSE	User has logged on - don't bother about reporting this one
Sheet1

Cell Formulas
Range	Formula
D2:D4	D2	=IF(AND(A2=TRUE,B2=TRUE,C2=TRUE),"Consider for removal",IF(AND(A2=FALSE,B2=FALSE,C2=FALSE),"User never logged on",IF(AND(A2=TRUE,B2=FALSE,C2=FALSE),"User has logged on - don't bother about reporting this one","")))

That's brilliant, i am so very grateful for this - such a quick reponse.

 

[etaf]

you are welcome