2 Replies Latest reply on May 9, 2012 12:27 AM by Sorbsbuster

# How do I increase this formula?

### Title

How do I increase this formula?

### Post

Hello,

I am trying to have the below formula increased.  So far this works for sorting half of my records but I need it to sort the other half.

If ( Sequence ≤ Record Count Group+1; (1+(Sequence-1)*4 ) ;If(Sequence > Record Count Group;1+(Sequence - Record Count Group-1) * 4)

I thought I could slam a ";"at the end and continue on with if formulas formula but I get a too many paramenters error.

The next parts need to have if(Sequence > Record Count Group*2+1;(1+(Sequence -(Record Count Group*2))-1) and  if(Sequence > Record Count Group*3+1;(1+(Sequence -(Record Count Group*3))-1)

I started thinking that maybe this is a case situation but I could only manage to get the first set of numbers assigned

Thank you,

JW

• ###### 1. Re: How do I increase this formula?

Please disregard.  I was having a syntax problem or something but I figured it out.

Thanks to anyone that started working on this.

If ( Record Count Group ≥ Sequence;1+(Sequence-1)*4;If ( Sequence  ≤ Record Group Top Right ; 2+(Sequence-Record Count Group-1)*4 ;If (Sequence ≤  Record Group Bottom Left;3+(Sequence-Record Group Top Right-1)*4;If ( Sequence ≤ Record Count ;4+(Sequence-Record Group Bottom Left-1)*4 ; "" ))))

• ###### 2. Re: How do I increase this formula?

A Case statement would be easier to manage.