Excel formula help required plz

Ok so i have the following columns in one excel sheet:
1. murexref
2. murexref
3. Status ( this column checks whether the data in the previous 2 columns matches.if it matches it populates a true or false accordingly.)
4. number
5. number
6. Status ( same status check here as 3.)
7. comments
now i want to insert a formula in comments column in such a way that it checks the entire row for false.the columns where it finds false it should indicate in the comments columns the column name where it found a false.is it possible?
thnx
Answer #1
Try this: it allows for both columns to contain ‘False’. =IF(C2=FALSE,IF(F2=FALSE,”murexref/number”,”murexref”),IF(F2=FALSE,”number”,””))
Obv, change the quoted text to display what you like.
Answer #2
it works but partially.if both are false itll return only one column any way to get both populated.
Answer #3
It checks for both being false, see first line of original msg. Perhaps some sample data?