Hi All
I would like to combine the 2 formulas below but I don't know how to do this.
FORMULA 1
=J015_100!S6
FORMULA 2
=IF(ISNUMBER(SEARCH("Y",J015_100!U6)),"APPROVED","")
I would like to display the value of formula 1, unless the value of formula 2 is "Y" in which case the value would be "APPROVED"
I hope the above makes some sense!!
Best regards,
Shahid
Bookmarks