| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Custum Cell Format - display 0 (zero) when cell is empty
Replace "" with "0" and see threresult .... IF(ISERROR(IF(MIN(IF(Sheet1!$F$3:$F$35C27,Sheet1! $F$3:$F$35))=0,"",MIN(IF(Sheet1!$F$3:$F$35C27,She et1!$F$3:$F$35)))),"[/color]", willemeulen;351337 Wrote: I change the formala from the second cell as follows: =IF(ISERROR(IF(MIN(IF(Sheet1!$F$3:$F$35C27,Sheet1 !$F$3:$F$35))=0,"",MIN(IF(Sheet1!$F$3:$F$35C27,Sh eet1!$F$3:$F$35)))),"",IF(MIN(IF(Sheet1!$F$3:$F$35 C27,Sheet1!$F$3:$F$35))=0,"",MIN(IF(Sheet1!$F$3:$ F$35C27,Sheet1!$F$3:$F$35)))) But there are no 0 (zero's) displayed. Is it not possible with the custom format of the cell, as this will not affect the formula at all, or will excell still read nothing? -- 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Empty Cell When Using SUM formula | Excel Worksheet Functions | |||
| format a cell with a formula so an empty reference cell shows blan | Excel Discussion (Misc queries) | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| Display a dialog box if cell is empty | Excel Discussion (Misc queries) | |||
![mubashir aziz[_22_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
