>Does anyone know how to write an "IF" statement such as @if(a=0,blank
>cell, b-c) where if a=0, the cell will be blank for averaging purposes,
>not zero or a label?
>
>Because I want to calculate numbers off that cell, the cell needs to be
>blank, not zero or a label which creates other problems. I am using
>Excel  5.0 but I remember that Lotus or older versions of Excel had a
>@blank function that may have done this.

use if(isblank(a1),0,a1)