Posted to microsoft.public.excel.worksheet.functions

sdwhite

external usenet poster

Posts: 1

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula won't hide	Karen	Excel Discussion (Misc queries)	1	March 19th 07 09:46 PM
Hide formula	Anand vijay	New Users to Excel	2	January 6th 07 01:11 PM
Hide Formula	BAIJU	Excel Discussion (Misc queries)	3	July 16th 06 08:00 AM
how to hide the formula	Thomas	Excel Worksheet Functions	1	October 27th 05 06:28 AM
Hide formula	skateblade	Excel Worksheet Functions	10	October 15th 05 08:36 PM

All times are GMT +1. The time now is 07:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us