how do you hide the #DIV/0! in a blank spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail: (e-mail address removed)
Laboratory Information Manager
VAMC Providence
 
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 :-)
------------------------------­------------------------------­----------------
 
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
 
Back
Top