Nested If's
Thank you for your reply. I had already tried that, but the problem is that
the "days" do not necessarily match those on the table. Where the table says
14, it means 14 days or less; 30 days or less, etc. My data table will show
a number, say 10 which would be in the 14 range.
But you gave me an idea. I inserted another column and entered this formula:
=IF(R4<15,"14",IF(R4<31,"30",IF(R4<151,"150",IF(R4 <361,"360",IF(R4<1096,"1096","9998"))))).
I will then use that value to concantenate to the account code.
So thanks!
-Beverly
|