rolYes you can:

=IF(IF(IF(IF(IF(IF(IF(IF(A1=1,1,1),1),1),1),1),1), 1),1)+IF(IF(IF(IF(IF(IF(IF(IF(A1=1,1,1),1),1),1),1 ),1),1),1)

It is really difficult to understand the logic in multiple nested if
statements and a user defined function is generally a lot easier to control
and check

you can also use 'and' and 'or' in if statements as

=IF(OR(A1=1,A2=1,A3=1,A4=1,A5=1,A6=1,A7=1,A8=1,A9= 1,A10=1),1,0)

-
Hope this helps
Martin Fishlock


"AcademyAce" wrote:

I have used up all seven nested functions in my formula but still have three
arguments left. I want to include them in the same cell.