I am trying to convert a formula from a lotus 123 cell to an excel cell. I don't know how to convert it to an excel formula.

If $K80is not0, set the cell's value toG8divided by$K8, otherwise set it to0. I assume it's an attempt to avoid a#DIV/0!error, but it's testing the wrong cell.

Ask Your Question

Weekly Poll