not showing blank cell

		Microsoft Office Forums > Microsoft Excel > Excel
not showing blank cell

FAQ

Thread Tools

Display Modes

03-13-2014, 11:18 AM

alw

Windows 7 64bit not showing blank cell

Office 2013

Novice

Join Date: Mar 2014

Posts: 8

not showing blank cell

=IFERROR(D3*E3,"") shows 0 instead of blank cell on error
=IFERROR(D3/H3,"") shows blank instead of 0 on error

I would like to show blank cells on error in both cases

Thankyou,
Al

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
won't show blank cell	bhum	Excel	2	01-28-2014 02:34 AM
Page numberring 1 - blank - 2 - blank etc	Intern	PowerPoint	0	09-02-2011 01:16 AM
How can I paste cell "A1" contents to cell "B1" if cell "A1" is not blank?	Learner7	Excel	1	04-25-2011 04:39 AM
How to turn all blank lines into non-blank for legal forms	sieler	Word	3	04-12-2009 01:38 PM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:49 PM.