Break Function

[Elren]

When more than seven levels of embedded IF statements are
required, you need to create a function macro, which
allows you to "break" your IF statement over several lines
(or formulas).
How do you create a function macro to do a "break" in a IF
statement as explained in the above sentence?

 

[J.E. McGimpsey]

It can be done in a variety of ways - what's your formula?

 

[Jim Chandler]

-----Original Message-----
When more than seven levels of embedded IF statements are
required, you need to create a function macro, which
allows you to "break" your IF statement over several lines
(or formulas).
How do you create a function macro to do a "break" in a IF
statement as explained in the above sentence?
.

 

[Jim Chandler]

-----Original Message-----
When more than seven levels of embedded IF statements are
required, you need to create a function macro, which
allows you to "break" your IF statement over several lines
(or formulas).
How do you create a function macro to do a "break" in a IF
statement as explained in the above sentence?
.

Your best bet would be to create a function that would
have the more than 7 levels of embedded IF statements.
For instance:

Function MyFunction()
if statement then
MyFunction = SomeValue
else if statement2 then
MyFunction = 2VAlue