If Statement Limit
 

Insert - Name - Define...
--
HTH...

Jim Thomlinson


"Rob" wrote:

It looks like it will work but I don't know how to name a formula.

"Jim Thomlinson" wrote:

Give Chip's site a look.

http://www.cpearson.com/excel/nested.htm
--
HTH...

Jim Thomlinson


"Rob" wrote:

How do you get around the Limit on the amount of Ifs allowed in a formula??

Here's my code that automatically inserted by a VBA Sub. I have exactly One
to many Ifs in it.


.FormulaR1C1 =
"=IF(R[10]C="""",=IF(RC[2]=FALSE,"""",IF(R[1]C[2]=FALSE,RC[2],IF(R[2]C[2]=FALSE,R[1]C[2],IF(R[3]C[2]=FALSE,R[2]C[2],IF(R[4]C[2]=FALSE,R[3]C[2],IF(R[5]C[2]=FALSE,R[4]C[2],IF(R[6]C[2]=FALSE,R[5]C[2],IF(R[7]C[2]=FALSE,R[6]C[2],R[7]C[2])))))))),=R[10]C)"


Thank You In Advance,
Rob

If Statement Limit
 

Ooooooo, So I put one of the IF statements into an empty cell and name the
cell then do the same for the rest and finally, apply those names to the cell
I need all of the statements in?

In other words...

Blankworksheet range A1 gets this...
=IF(RC[2]=FALSE,"""",IF(R[1]C[2]=FALSE,RC[2],IF(R[2]C[2]=FALSE,R[1]C[2],IF(R[3]C[2]=FALSE,R[2]C[2],IF(R[4]C[2]=FALSE,R[3]C[2],IF(R[5]C[2]=FALSE,R[4]C[2],IF(R[6]C[2]=FALSE,R[5]C[2],IF(R[7]C[2]=FALSE,R[6]C[2],R[7]C[2]))))))))
....And I name the cell it's in "SomeName"

Needed worksheet get range A16 gets this... =IF(R[10]C="""",SomeName,R[10]C)

I'll give it a go. Thanks Bunches. ;))

Rob


"Jim Thomlinson" wrote:

Insert - Name - Define...
--
HTH...

Jim Thomlinson


"Rob" wrote:

It looks like it will work but I don't know how to name a formula.

"Jim Thomlinson" wrote:

Give Chip's site a look.

http://www.cpearson.com/excel/nested.htm
--
HTH...

Jim Thomlinson


"Rob" wrote:

How do you get around the Limit on the amount of Ifs allowed in a formula??

Here's my code that automatically inserted by a VBA Sub. I have exactly One
to many Ifs in it.


.FormulaR1C1 =
"=IF(R[10]C="""",=IF(RC[2]=FALSE,"""",IF(R[1]C[2]=FALSE,RC[2],IF(R[2]C[2]=FALSE,R[1]C[2],IF(R[3]C[2]=FALSE,R[2]C[2],IF(R[4]C[2]=FALSE,R[3]C[2],IF(R[5]C[2]=FALSE,R[4]C[2],IF(R[6]C[2]=FALSE,R[5]C[2],IF(R[7]C[2]=FALSE,R[6]C[2],R[7]C[2])))))))),=R[10]C)"


Thank You In Advance,
Rob