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
1916
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 16, 2021
142
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 :)

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!