# Word "False" kept on Appearing? =IF function

Solved/Closed
InfoTech04 Posts 2 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015 - Aug 19, 2015 at 09:33 AM
InfoTech04 Posts 2 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015 - Aug 19, 2015 at 10:20 PM
=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data"))))

How is it happen that I put "Incomplete Data" then word "False" Appear.

Related:

## 1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 19, 2015 at 12:37 PM
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.
Marcílio Lobão
InfoTech04 Posts 2 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015
Aug 19, 2015 at 10:20 PM
Thank You so Much, It's so Helpful :) That is what I am Looking For :) Thank You :)