Remove "FALSE" from a formula
Solved
dams63100
Posted messages
562
Registration date
Status
Member
Last intervention
-
dams63100 Posted messages 562 Registration date Status Member Last intervention -
dams63100 Posted messages 562 Registration date Status Member Last intervention -
Hello everyone,
I have tried many things to remove the "FALSE" in my formula but ended up with an error,
so I'm asking for your help:
=IFERROR(IF(COUNTIF($C$19,$I$11)>0,IF(AND($L$11>=C$1,$L$11<=C$2),(C5*($C$11+$F$11)),0)))
The formula works but shows FALSE when it shouldn't; I just want to replace it with nothing, there must be a missing ";" " " somewhere but where?
Thank you!
Configuration: Macintosh / Firefox 97.0
--
Configuration:
Windows 7 Ultimate x64, Intel Core i7 950, 8GB DDR3, Radeon HD 6970 2GB, Caviar SATA 3.0 - 640GB - 64MB + 3820GB external
I have tried many things to remove the "FALSE" in my formula but ended up with an error,
so I'm asking for your help:
=IFERROR(IF(COUNTIF($C$19,$I$11)>0,IF(AND($L$11>=C$1,$L$11<=C$2),(C5*($C$11+$F$11)),0)))
The formula works but shows FALSE when it shouldn't; I just want to replace it with nothing, there must be a missing ";" " " somewhere but where?
Thank you!
Configuration: Macintosh / Firefox 97.0
--
Configuration:
Windows 7 Ultimate x64, Intel Core i7 950, 8GB DDR3, Radeon HD 6970 2GB, Caviar SATA 3.0 - 640GB - 64MB + 3820GB external
2 answers
Hello.
Your formula =IFERROR(IF(COUNTIF($C$19,$I$11)>0;IF(AND($L$11>=C$1;$L$11<=C$2);(C5*($C$11+$F$11));0))) is incorrect: The third argument "value_if_false" is missing for the first IF function, as well as the value to display when IFERROR finds a false value.
=IFERROR(IF(COUNTIF($C$19,$I$11)>0; IF(AND($L$11>=C$1;$L$11<=C$2);(C5*($C$11+$F$11));0) ))
=IFERROR(IF(COUNTIF($C$19,$I$11)>0; IF(AND($L$11>=C$1;$L$11<=C$2);(C5*($C$11+$F$11));0) ;0 ) ;0 )
--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA)
Your formula =IFERROR(IF(COUNTIF($C$19,$I$11)>0;IF(AND($L$11>=C$1;$L$11<=C$2);(C5*($C$11+$F$11));0))) is incorrect: The third argument "value_if_false" is missing for the first IF function, as well as the value to display when IFERROR finds a false value.
=IFERROR(IF(COUNTIF($C$19,$I$11)>0; IF(AND($L$11>=C$1;$L$11<=C$2);(C5*($C$11+$F$11));0) ))
=IFERROR(IF(COUNTIF($C$19,$I$11)>0; IF(AND($L$11>=C$1;$L$11<=C$2);(C5*($C$11+$F$11));0) ;0 ) ;0 )
--
Retirement is great! Especially in the West Indies...
Raymond (INSA, AFPA)
dams63100
Posted messages
562
Registration date
Status
Member
Last intervention
44
Thank you Raymond, as always it's perfect!
Hello
To test
=IFERROR(IF(COUNTIF($C$19,$I$11)>0,IF(AND($L$11>=C$1,$L$11<=C$2),(C5*($C$11+$F$11)),"")))
Best regards
--
Start by doing what is necessary, then do what is possible, and you will achieve the impossible without realizing it. Saint Francis of Assisi
To test
=IFERROR(IF(COUNTIF($C$19,$I$11)>0,IF(AND($L$11>=C$1,$L$11<=C$2),(C5*($C$11+$F$11)),"")))
Best regards
--
Start by doing what is necessary, then do what is possible, and you will achieve the impossible without realizing it. Saint Francis of Assisi
Hello,
it's not working, I'm trying to export to Excel (I'm on Google Sheets) but it doesn't even want to take the formula haha
I took a screenshot if that can help: https://www.zupimages.net/up/22/10/fpzj.png
it's not working, I'm trying to export to Excel (I'm on Google Sheets) but it doesn't even want to take the formula haha
I took a screenshot if that can help: https://www.zupimages.net/up/22/10/fpzj.png