Using "IF" statements

[USMCFROSTY]

Hi,
Im using =if(A1=4,"X") to mark with an x on certain cells. The problem is that i can't seem to figure out how to skip a row without doing each row indivdually. I should be able to just use this formula and drag it down.

 

[SRAB]

Hi,
Im using =if(A1=4,"X") to mark with an x on certain cells. The problem is that i can't seem to figure out how to skip a row without doing each row indivdually. I should be able to just use this formula and drag it down.

Can you define the condition that is causing you to skip a row?

 

[USMCFROSTY]

My if statement works fine but i only want to look at every 4th cell in the column. It's all text except the 4th one which is a # that im using the if on. So ideally 1,5,9,13........... I guess i need somthing nested within my if statement?

 

[SRAB]

My if statement works fine but i only want to look at every 4th cell in the column. It's all text except the 4th one which is a # that im using the if on. So ideally 1,5,9,13........... I guess i need somthing nested within my if statement?

I guess I'm not understanding the problem. If row 2,3 & 4 are text, then it won't = 4, and therefor won't get an X.

 

[USMCFROSTY]

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". The problem is that i only want this statement to apply to every 4th cell going down the row

 

[WayneRyan]

Frosty,

You're treating your table like a spreadsheet. The same column should not have different
data types in it.

A very short-term workaround would be to base your report on a query.
Add a new invisible column to the query --> NewClm: IsNumeric([YourColumnName])
And set its criteria to True.

Then you'll only print the rows where that column has a numeric entry.

More beneficial, would be to structure your table so that it conforms to database
rules, as opposed to spreadsheet rules.

Wayne

 

[USMCFROSTY]

I changed column to say rows i have 400 rows and one column. And want to use the if statement in incraments of 4.

 

[WayneRyan]

Frosty,

And you still only want to display the numeric data??

Wayne

 

[USMCFROSTY]

yes because row 1 is a # row 234 are text, row 5 is a # ect and i wrote a if statement for each # but only want to look at every 4 row which are the #'s

Thanks so much

 

[WayneRyan]

Frosty,

You have to restrict the number of rows which you feed to the report.

Use a query and the method in Post #6 of this thread.

Wayne

 

[USMCFROSTY]

I don't think i understand post 6.