Mattster2020
06-24-2009, 02:57 AM
Morning All,
I am using a simple divide forumla (E5/F5) in cell (H5) to return an average. Is there anyway that if the contents of E5 and F5 are zero that a blank cell or zero can be returned instead of DIV/0!.
Regards,
Matt
I am using a simple divide forumla (E5/F5) in cell (H5) to return an average. Is there anyway that if the contents of E5 and F5 are zero that a blank cell or zero can be returned instead of DIV/0!.
Regards,
Matt