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.