Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you hide the #DIV/0! in a blank spreadsheet?
-- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you hide the #DIV/0! in a blank spreadsheet?
Assuming your formula is =A1/A2 then use
=IF(A2=0,0,A1/A2) -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "John Gentile" wrote in message ... -- John Gentile, MS M(ASCP) Phone: (401) 273-7100 ext 2046 Fax: (401) 457-3069 e-mail: Laboratory Information Manager VAMC Providence |
#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 |
Reply |
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 |