How do I make a cell appear empty when the formula = 0?

t1202

Posts: n/a

How do I make a cell appear empty when the formula = 0?

If the answer to the formula is 0, how can I make it just show the cell as
empty instead of actually putting a 0 in the cell?

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 HELP	Jay	Excel Worksheet Functions	3	October 14th 05 05:13 AM
how do i make a cell date sensitive to execute a formula or input.	ebuzz13	Excel Discussion (Misc queries)	2	January 20th 05 08:33 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell	[email protected]	New Users to Excel	2	January 6th 05 07:18 AM
make a cell empty based on condition	mpierre	Charts and Charting in Excel	2	December 29th 04 01:01 PM
make cell contents equal to null value - not blank, but empty	mpierre	Excel Worksheet Functions	1	December 29th 04 06:57 AM

All times are GMT +1. The time now is 11:48 PM.

About Us