Overcome Nested IF formula limit

Hello,

I have left my brain at home today :\

Could someone please advise on how I would achieve this:

I have 10 columns C2:L2

I want to check all of the columns and check if any of the values in these columns are not equal to #N/A or '0'

If any of the 10 columns contain values other than the #N/A or 0 then put the relevant TRUE / FALSE in column M.
I tried:

Please Login or Register  to view this content.

but I forgot the nested IF limit is 7



Can anyone help me please?


Thanks in Advance.

Thankyou for that SHORT version!


Basically,

I have an account number in A2

Column C to L are the REP Managerss for the accounts.


the managers have indicated in these columns whether the account is to be included in another report.

column C manager has put "NO" next the accounts he dont want included.
column D manager has also put "NO" next to the accounts he dont want included.
column E manager has put "DO NOT INCLUDE" next to the accounts.

there is no consistency!!

thats why I chose to use >0 as the search filter.

I have VLOOKUP from 10 spreadsheets into these columns. Copy & paste special, then in column M, have a 1 or a 0 if any of the cells contain anything other than #N/A or 0


your formula worked for me!

although I had already done it using this extremley long one:

Please Login or Register  to view this content.

Thankyou for your help!