| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you hide the #DIV/0! in a blank spreadsheet?
Couple of ways.
1 - use conditional formatting with this formula =ISERROR(C1) format font color same as background color 2 - alter your formula so that it will return blank or zero if a certain cell is empty =IF(B1="","",A1/B1) HTH Jean-Guy "John Gentile" wrote: -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to hide rows if cell is blank | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| Moving Around a Blank Spreadsheet | Excel Worksheet Functions | |||
| pivot tables reports - altering display of (blank) cells | Excel Worksheet Functions | |||
| BLANK EXCEL PAGE STILL EXIST AFTER I CLOSE OUT SPREADSHEET? | New Users to Excel | |||
Threaded Mode
