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