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.

1 reply

Mazzaropi
Posts
1965
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 18, 2022
146
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
1
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 :)
0