Posted to microsoft.public.excel.newusers

smiley61799 smiley61799 is offline

external usenet poster

Posts: 17

look up tables and getting rid of the #N/A

When you do not have information for a cell how do you get it to leave the
cell blank or return a zero as opposed to the #N/A

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
Building pivot tables in Excel 2007 based on existing pivot tables?	[email protected]	Excel Discussion (Misc queries)	4	December 26th 07 08:05 PM
Help with tables	Steve P.	Excel Discussion (Misc queries)	5	July 27th 07 02:34 PM
Tables	Mike M	Excel Discussion (Misc queries)	2	April 20th 07 04:54 PM
Two new tables from one	Richard O. Neville	Excel Discussion (Misc queries)	0	March 15th 06 03:12 PM
Look up tables	mark_b2410	Excel Discussion (Misc queries)	2	October 21st 05 05:33 PM

All times are GMT +1. The time now is 10:55 PM.

About Us

"It's about Microsoft Excel"