Thread: Custum Cell Format - display 0 (zero) when cell is empty
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
mubashir aziz[_16_] mubashir aziz[_16_] is offline
external usenet poster
  
Posts: 1
Default Custum Cell Format - display 0 (zero) when cell is empty

Replace this formula = SMALL(Sheet1!F3:F35,1) with below formula

=IF(ISERROR(SMALL(Sheet1!F3:F35,1)),"",SMALL(Sheet 1!F3:F35,1))




willemeulen;351291 Wrote:
The first cell is the following:
=SMALL(Sheet1!F3:F35,1)
After that it is:
=IF(MIN(IF(Sheet1!$F$3:$F$35C27,Sheet1!$F$3:$F$35 ))=0,"",MIN(IF(Sheet1!$F$3:$F$35C27,Sheet1!$F$3:$ F$35
)))
My problem is when there is no value in the cell another formula using
this cell to lookup a small table cant find any result and displays
#N/A; I don't like this to be displayed but mainly when the summary
table contains #N/A the totals change into #N/A as well.
W


--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98209

Reply With QuoteReply With Quote