Have a result from several conditions on google sheets-CodePudding

I have set up a Sheets file to have the list of the personnel of a company. Each line corresponds to a person and each column to a data of this same person. There is the date of entry in the company, the name of the person, his first name, if he followed the mandatory training and if he was present the first day of work.

I am trying to set up indicators and one of them is causing a problem. I would like to have a column where a certain result appears based on the data entered in the "here in formation?" and "here 1st day?" columns. Unfortunately, I can't combine the logical AND operator in my IFS to get the desired result.

You can see via

CodePudding user response：

supreme fx:

=INDEX(IF(B2:B="";;IF(REGEXMATCH(D2:D&E2:E; 
 "^No(?: need)?(?:No)?$"); "No"; 
 IF(E2:E=""; "Data not completed"; E2:E))))