View original (French)

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   -
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 Posted messages 58229 Registration date   Status Contributor Last intervention   17 492
     
    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 Posted messages 562 Registration date   Status Member Last intervention   44
       
      Thank you Raymond, as always it's perfect!
      0
  2. JCB40 Posted messages 3069 Registration date   Status Member Last intervention   479
     
    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 Posted messages 562 Registration date   Status Member Last intervention   44
       
      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