View original (French)

Formula if cell is not empty

Solved
sev33130 Posted messages 35 Status Membre -  
sev33130 Posted messages 35 Status Membre -
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 réponses

Réponse 1 / 3
Mike-31 Posted messages 18405 Registration date   Status Contributeur Last intervention   5 145
 
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
sev33130 Posted messages 35 Status Membre 3
 
Good. It works.

Thank you Mike-31

Have a good day.

Sév 33130
0