IF Multiple Cells to give a set response

[ActionDan69]

Hello long time reader, 1st time poster:I have a spreadsheet which uses =F to give set responses i.e.

Cell H35= =IF((G7-G35)=0,"No Issue",IF((G7-G35)>=1,"System/Paperwork do not Match",IF((G7-G35)<0,"System/Paperwork do not Match",)))

I want a cell that will display "Issue identified" when cells all or any of Cells H35, K35, N35 etc. Display the message "System/paperwork do not Match".

Please help?

 

[pgc01]

Hi
Welcome to the board

Assuming the message can only appear in those cells an not in the ones in between (like I35, J35, etc.), try:


=IF(COUNTIF(H35:N35,"System/paperwork do not Match" ),"Issue identified","")

 

[ActionDan69]

Thank you that seems to have done it, I was hung up on trying to add/and combine the fields.

once again many thanks

 

[pgc01]

You're welcome. Thanks for the feedback.