View original (French)

If A1 is empty then B1 = empty and if A1 has a value then B1 = C1 - A1

Solved
Chewychewba Posted messages 3 Status Membre -  
Chewychewba Posted messages 3 Status Membre -
Hello,

I would like to enter the following function:

if A1=nothing then B1 = nothing and if A1=value then B1 = C1-A1

Thanks in advance.

3 réponses

Réponse 1 / 3
ccm81 Posted messages 11033 Status Membre 2 434
 
Hello

to be put in B1
=IF(A1="","",C1-A1)

best regards
1
Réponse 2 / 3
Chewychewba Posted messages 3 Status Membre
 
Thank you very much.
0
Réponse 3 / 3
Chewychewba Posted messages 3 Status Membre
 
Another topic related to this formula,
The values of this formula are returned in a graph, the problem is that when there is no value a point is plotted at 0, I would like nothing to be displayed, is it possible?
0