| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
| Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
| Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
| appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Linear Mode
