View original (French)

Formula if cell is not empty

Solved
sev33130 Posted messages 35 Status Member -  
sev33130 Posted messages 35 Status Member -
Hello,

I need to set up a formula that allows me to enter the number "1" in my cell if another cell is filled.

For example: If C388 is filled, then H388 = 1

I tried using =IF(C388=full;H388=1;"") but it doesn't work.

Thank you for your help.

Best regards.

Have a nice day.

Sév 33130

3 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hi,

    so in H388 this formula
    =if(C388<>"";1;"")

    --
    A+
    Mike-31

    Not knowing is not a failure, failure is the refusal to learn.
    7
    1. sev33130 Posted messages 35 Status Member 3
       
      Good. It works.

      Thank you Mike-31

      Have a good day.

      Sév 33130
      0