I need for a formula to recognize a blank cell and do nothing however when i
put a zero in the blank cell I need the formula to work, right now it is
looking at the blank cell and zero as the same and preforming the formula.
any suggestions.