how to add two if formula

**nur2544** · 01-21-2013, 10:23 AM

Individually both formula are working fine but How to implement both formula in single formula

Please Login or Register  to view this content.

i have tried something like this but not working

Please Login or Register  to view this content.

**zbor** · 01-21-2013, 10:24 AM

Try this

Formula:

Please Login or Register  to view this content.

**Tony Valko** · 01-21-2013, 10:29 AM

Try it like this...

=IF(COUNT(SEARCH({"TRE","MGW"},A1)),A1,"")

**Tony Valko** · 01-21-2013, 10:33 AM

That won't work for the second SEARCH criteria, MGW.

You'd have to do it like this:

=IF(OR(ISNUMBER(SEARCH({"TRE","MGW"},A1))),A1,"")

**nur2544** · 01-21-2013, 10:37 AM

Hi, Tony
Your solution is great. Thanks..

**nur2544** · 01-21-2013, 10:42 AM

Hi, Zbor
your solution is not working, but i already got the solution from "Tony" is working fine for me.. thanks both of guys.

**Tony Valko** · 01-21-2013, 10:43 AM

You're welcome. Thanks for the feedback!

**zbor** · 01-21-2013, 10:45 AM

Originally Posted by nur2544

Hi, Zbor
your solution is not working, but i already got the solution from "Tony" is working fine for me.. thanks both of guys.

Yes, I saw when I saw TV formula. I was writing without testing.
But didn't edit since you got answer

Re: how to add two if formula