Hello, I have a formula here that has 2 Criteria which is Master1 and Master2. I would like to add another one which is Master3, can you help me compose the formula base on the formula that I gave.
Formula:
=IF(OR(ISNUMBER(SEARCH("Master1",'Recharge Backend'!$G$2:$G$9999)),ISNUMBER(SEARCH("Master2",'Recharge Backend'!$G$2:$G$9999))),'Recharge Backend'!$D2&" "&'Recharge Backend'!$A2&" "&'Recharge Backend'!$B2&" "&'Recharge Backend'!$R2&" "&'Recharge Backend'!$F2,"")
Formula:
=IF(OR(ISNUMBER(SEARCH("Master1",'Recharge Backend'!$G$2:$G$9999)),ISNUMBER(SEARCH("Master2",'Recharge Backend'!$G$2:$G$9999))),'Recharge Backend'!$D2&" "&'Recharge Backend'!$A2&" "&'Recharge Backend'!$B2&" "&'Recharge Backend'!$R2&" "&'Recharge Backend'!$F2,"")