IF Statements

[David]

I am trying to create an if statement that will classify receivables into
various categories (ie 0-30 days old, 31-60 days old etc..) based on their
age. I can't seem to get the full IF statement that will read the data and
put it into 1 of 7 categories.

 

[Fred Smith]

OK. I'll bite. What data do you have, and what categories do you want? Also,
what formulas have you tried?

Regards,
Fred.

 

[David]

I have a list of AR dollars that need to be classified into the following
categories:

0-30
31-60
61-90
91-120
120-180
181-360
360+

I have tried a number of permutations of complex IF statements that usually
end up returning either an error message or a "false".

 

[David]

I GOT IT !!!

I have a list of AR dollars that need to be classified into the following
categories:

0-30
31-60
61-90
91-120
120-180
181-360
360+

I have tried a number of permutations of complex IF statements that usually
end up returning either an error message or a "false".