- Registration date
- Monday August 16, 2010
- Last seen
- October 17, 2020
InfoTech04, Good afternoon.
This is happening because one of the cells that are in the formula is EMPTY or content TEXT (space).
If the content of some of them is ZERO (0) then you will see "Incomplete Data" response.
Just out of curiosity, make this small change in the formula and you will know which cell is generating the error:
=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data"),"C1, ERROR"),"B1 ERROR"),"A1 ERROR")
Is that what you're looking for?
I hope it helps.
Belo Horizonte, Brasil.