Word "False" kept on Appearing? =IF function [Solved/Closed]

Report
Posts
2
Registration date
Wednesday August 19, 2015
Status
Member
Last seen
August 19, 2015
-
Posts
2
Registration date
Wednesday August 19, 2015
Status
Member
Last seen
August 19, 2015
-
=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

Posts
1837
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 17, 2020
136
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Wednesday August 19, 2015
Status
Member
Last seen
August 19, 2015

Thank You so Much, It's so Helpful :) That is what I am Looking For :) Thank You :)