USMCFROSTY
Registered User.
- Local time
- Today, 05:45
- Joined
- Mar 5, 2007
- Messages
- 64
I want to use an if statement but in increments of 4.
The situation is this:
I have 400 rows. Row 1 is a # row 234 are text, row 5 is a # ect…. I wrote a if statement for each #-(My if statement is set up to say if the # is a 1 to mark it as "A" if a 2 "B" if a 3"C" if a 4"X"). But I only want to look at every 4 row which are the #'s. The problem is that i only want this statement to apply to every 4th cell going down the column. If I write It once then drag it down it doesn’t work. I think I have to have a nested statement within my If statement but have no idea how.
Help plz
The situation is this:
I have 400 rows. Row 1 is a # row 234 are text, row 5 is a # ect…. I wrote a if statement for each #-(My if statement is set up to say if the # is a 1 to mark it as "A" if a 2 "B" if a 3"C" if a 4"X"). But I only want to look at every 4 row which are the #'s. The problem is that i only want this statement to apply to every 4th cell going down the column. If I write It once then drag it down it doesn’t work. I think I have to have a nested statement within my If statement but have no idea how.
Help plz