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.

you can have more than 7 If functions nested in Vb code
"AcademyAce" wrote in message
...
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.

you can post your formula to see if this forum can help you.

"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.

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.

With 10 options it's usually better to use some sort of LOOKUP formula. If
you have the most simple structure like

IF(A1="a",2,IF(A1="b",3 ......etc then this can usually be simplified by
constructing a 2 column table and using a VLOOKUP formula

"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.

you're right..

i just want to know here, (other than lookup results) if the number of
different value-if-true results...requires more than 7 and are structured
independently..... then nesting Maybe is a must...
let's wait for AcademyAce to post his formula n Results needed... he sounds
like an experienced excel user.

"daddylonglegs" wrote:

With 10 options it's usually better to use some sort of LOOKUP formula. If
you have the most simple structure like

IF(A1="a",2,IF(A1="b",3 ......etc then this can usually be simplified by
constructing a 2 column table and using a VLOOKUP formula

"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.