As you can learn from my solution you don't need more than one IF statement.
Basically:
Up to "Excel 2003" (incl.) you can nest 7 IF Statements.
From "Excel 2007" you can nest 64 IF Statements.
Usually, no one nests that many statements - not even 7
In such cases one uses a small table with all the possibilities and returns
the result with VLOOKUP.
Micky


"vinstream" wrote:

Thanks a ton...this is working.

How many If statements can I use in one formula?






On Apr 7, 11:12 am, "ozgrid.com" wrote:
Hello,

Try;
=IF(OR(ISNUMBER(SEARCH("testing",A1)),ISNUMBER(SEA RCH("cold",A1)),ISNUMBER(Â*SEARCH("working",A1))), "Yes","No")"vinstream" wrote in message

...



Hi,

I have the following sample data in column A.

germany (testing)
Germany (cold)
Germany
Austria (Testing)
Austria (cold)
Austria (working)
Austria (other)
China
China (alternate)

In column B, I want it to show that if the cell to the left has any of
the words 'testing' or 'cold' or 'working' it should show "yes" in
Column B else show "no".

Is this possible?

Regards,

Vinstream- Hide quoted text -

- Show quoted text -

.