Forum Discussion

GEEK_21's avatar
GEEK_21
Brass Contributor
May 28, 2023
Solved

Hide False value based on a another cell value | Help

Hello everyone.I have an excel file with the if function based on the value of another cell. When cell AG3 for example has a value, so a note is displayed in cell AH3. And if there is no value in ce...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 28, 2023

    GEEK_21 

    Like this:

     

    =SIERREUR(SI(COUNTBYFONTCOLOR(A3:B3;1);SI(AG3<=0;"";SI(AG3<=2,5;"A";SI(AG3<=4,5;"B";SI(AG3<=6,5;"C";SI(AG3<=8;"D";SI(AG3<=9;"E";SI(AG3<=10;"F";"")))))));SI(COUNTBYFONTCOLOR(A3:B3;3);SI(AG3<=0;"";SI(AG3<=2,5;"G";SI(AG3<=4,5;"H";SI(AG3<=6,5;"I";SI(AG3<=8;"J";SI(AG3<=9;"K";SI(AG3<=10;"L";"")))))));""));"")

HansVogelaar's avatar
HansVogelaar
MVP
May 28, 2023

GEEK_21 

For example

 

=SIERREUR(SI(OU(COUNTBYFONTCOLOR(A3:B3;1);COUNTBYFONTCOLOR(A3:B3;3));SI(AG3<=0;"";SI(AG3<=2,5;"A";SI(AG3<=4,5;"B";SI(AG3<=6,5;"C";SI(AG3<=8;"D";SI(AG3<=9;"E";SI(AG3<=10;"F";"")))))));"");"")

 

or

 

=SIERREUR(SI(OU(COUNTBYFONTCOLOR(A3:B3;1);COUNTBYFONTCOLOR(A3:B3;3));SI.CONDITIONS(AG3<=0;"";AG3<=2,5;"A";AG3<=4,5;"B";AG3<=6,5;"C";AG3<=8;"D";AG3<=9;"E";AG3<=10;"F";VRAI;"");"");"")

  • GEEK_21's avatar
    GEEK_21
    Brass Contributor
    May 28, 2023

    HansVogelaar 

     

    Sorry sir I made a mistake my formula must be like this

     

    =SIERREUR(SI(COUNTBYFONTCOLOR(A3:B3;1);SI(AG3<=0;"";SI(AG3<=2.5;"A";SI(AG3<=4.5;"B";SI(AG3<=6.5;"C";SI(AG3<=8;"D";SI(AG3<=9;"E";SI(AG3<=10;"F")))))));SI(COUNTBYFONTCOLOR(A3:B3;3);SI(AG3<=0;"";SI(AG3<=2.5;"G";SI(AG3<=4.5;"H";SI(AG3<=6.5;"I";SI(AG3<=8;"J";SI(AG3<=9;"K";SI(AG3<=10;"L")))))))));"")

     

    The notes of the countyfontcolor 1 function should not be the same as countyfontcolor 3

     

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 28, 2023

      GEEK_21 

      Like this:

       

      =SIERREUR(SI(COUNTBYFONTCOLOR(A3:B3;1);SI(AG3<=0;"";SI(AG3<=2,5;"A";SI(AG3<=4,5;"B";SI(AG3<=6,5;"C";SI(AG3<=8;"D";SI(AG3<=9;"E";SI(AG3<=10;"F";"")))))));SI(COUNTBYFONTCOLOR(A3:B3;3);SI(AG3<=0;"";SI(AG3<=2,5;"G";SI(AG3<=4,5;"H";SI(AG3<=6,5;"I";SI(AG3<=8;"J";SI(AG3<=9;"K";SI(AG3<=10;"L";"")))))));""));"")

      • GEEK_21's avatar
        GEEK_21
        Brass Contributor
        May 28, 2023
        Yes it works thank you
  • GEEK_21's avatar
    GEEK_21
    Brass Contributor
    May 28, 2023
    Thank you very much

Resources