--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail: [email protected]
Laboratory Information Manager
VAMC Providence
--
John Gentile, MS M(ASCP)
Phone: (401) 273-7100 ext 2046
Fax: (401) 457-3069
e-mail: [email protected]
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 :-)
------------------------------*------------------------------*----------------
"John Gentile" <[email protected]> wrote in message
news:[email protected]...
>
> --
> John Gentile, MS M(ASCP)
> Phone: (401) 273-7100 ext 2046
> Fax: (401) 457-3069
> e-mail: [email protected]
> Laboratory Information Manager
> VAMC Providence
>
>
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: [email protected]
> Laboratory Information Manager
> VAMC Providence
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks