Excel Cell already has formula and can not apply a second formula.
Posted on 2016-10-26
I have three great formulas the looks across columns for DONE in cells and then gives a percentage in the last column.
The problem is, all the cells already have a formula in them that is putting the DONE in the cell.
Here are the formulas. (all work great if it is just TEXT, but not if a formula is already in the cell)