Combine 2 formulas

[Shahid_Excel]

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

[6StringJazzer]

Maybe this?

Please Login or Register  to view this content.

[Shahid_Excel]

Hi Jeff

Thank you so much, works just as i wanted

Best regards,

Shahid