View original (French)

Remove "FALSE" from a formula

Solved
dams63100 -  
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

2 answers

  1.  Raymond PENTIER Contributor
    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)
    1
    1. dams63100 Author
      Thank you Raymond, as always it's perfect!
      0
  2. JCB40
    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
    0
    1. dams63100 Author
      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
      0