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.

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

Regards,
Fred.

"David" wrote in message
...
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.

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".

"Fred Smith" wrote:

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

Regards,
Fred.

"David" wrote in message
...
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.

I GOT IT :-)!!!

"David" wrote:

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".

"Fred Smith" wrote:

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

Regards,
Fred.

"David" wrote in message
...
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.