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