divide by zero
belliotb wrote:
i have 2 cells: f4 and f8 on status spreadsheet. they may
not be populated, (have a value in the cell), all the time.
need a formula that will calculate when only both of them
are populated. and not return a #div/0!, divide by zero error,
when neither or only one of those cells are populated
=if(or(f4="", f8="", f8=0), "", f4/f8)
|