On 18 May, 22:09, sdwhite wrote:
I'm trying to write an IF formula referencing a cell (in the row) that is a 1
or 0; =if(cell=0,"no","yes"). If the cell is 1 (yes) I want to hide the row.
Any suggestions?

Hi sdwhite

Use Data Filter AutoFilter on the column containing your 1s.

Drop down the filter button and select (Custom...)

Choose "does not equal" from the first list and enter 1 in the next
field.

Regards

Steve