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:

=IF(C2>0,1,
IF(D2>0,1,
IF(E2>0..... etc etc etc

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:

=IF(C20>0,1,"")&IF(D20>0,1,"")&IF(E20>0,1,"")&IF(F20>0,1,"")&IF(G20>0,1,"")&IF(H20>0,1,"")&IF(I20>0,1,"")&IF(J20>0,1,"")&IF(K20>0,1,"")&IF(L20>0,1,"")

Thankyou for your help!