Formula Adjustments 1

[Jason2121]

Hello,

I am trying to adjust a Formula for a Subsidiary Company for Consolidation. I can add the Account to a particular Range of Accounts but I can not remember how to say not in a range in Accounts. Please see below...

If {@Accounts} < "5299.999999" or {@Accounts} in "5301" to "5999" and {@Accounts} in "3.6540.1" Then "Non-Regulated Income" else

trying to say not the account "3.6540.1" in this parameter

If {@Accounts} in "6500" to "6540.999999" Then "Plant Non-Specific Operations" else



Thanks for the help

Jason

 

[lbass]

Please say in words what this formula is intended to do.

-LB

 

[Jason2121]

I am trying to make the GL Account 3.6540.1 go into a Summarized Group of Accounts that range from 5033 - 5999.9999. This Company has five divisions and on of them is using this Account for a specific Exp. How can I write a formula line to not include it into the "6500" to "6540.999999" range, but allow it to be pulled from the "5301" to "5999"

What I have now;
If {@Accounts} < "5299.999999" or {@Accounts} in "5301" to "5999" and {@Accounts} in "3.6540.1" Then "Non-Regulated Income" else

and

If {@Accounts} in "6500" to "6540.999999" Then "Plant Non-Specific Operations" else

Jason

 

[lbass]

I think you should avoid using "in" with string values, since, for example, "650" is IN "6500". Are you also trying to exclude {@Accounts} = "5300" by using the first two lines?

Try a formula like this:

if val({@Accounts}) < 5299.999999 or
val({@Accounts}) in 5301 to 5999 or
{@Accounts} = "3.6540.1" Then
"Non-Regulated Income" else
If val({@Accounts}) in 6500 to 6540.999999 Then
"Plant Non-Specific Operations" else

-LB

 

[Jason2121]

This was huge. I used the formula on all my clients.

The guy here before me had some wierd Forms. but thanks for your help!