Break Function

  • Thread starter Thread starter Elren
  • Start date Start date
E

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?
 
-----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?
.
Click to expand...
 
-----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?
.
Click to expand...

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
 
Back
Top