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 |
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 |
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 |
All times are GMT +1. The time now is 02:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com