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
InfoTech04 Posts 2 Registration date Wednesday August 19, 2015 Status Member Last seen August 19, 2015 - Aug 19, 2015 at 10:20 PM
Related:
- Word "False" kept on Appearing? =IF function
- Word apk for pc - Download - Word processors
- Word watermark on all pages - Guide
- Number to text in word - Guide
- Find function on mac - Guide
- Word 2007 pdf add on - Download - Other
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
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
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
Aug 19, 2015 at 10:20 PM