1 Reply Latest reply: Jul 9, 2018 8:42 AM by Chris Porthouse RSS

    Using the If statement/Aging

    henry garza

      I have a column of data for each invoice account ranging from 0 to 300.  How would I use a calculated formula to take my data field, AGE, and have a calculated column represent into categories.  For example, if the number is in the 0 to 30 range, I want a category to be 0-30, 31-60, 61-90, 90-120, ETC. 

        • Re: Using the If statement/Aging
          Chris Porthouse

          There are a couple of solutions, but the easiest might be to use a nested if statement. For simplicity, I am going to show how to break down from 0-120.



          you can also write it like this to make it more understandable:







          Another option would be to use a lookup table as well.