View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sdwhite sdwhite is offline
external usenet poster
 
Posts: 1
Default formula to hide row

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?