View original (French)

Do not calculate a sum if the cell is empty

Solved
Aztek33 Posted messages 553 Registration date   Status Member Last intervention   -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I would like to know the formula to display an error message if one of the cells in my calculation is empty.

For example, my cell A5:
=A1+A2+A3+A4

But if one of these cells is empty, I would like cell A5 to show a message saying that the sum is impossible because one of these cells is empty. I think I need to use the ISBLANK function, but I'm not sure how.

Thank you for your help.

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello

    =IF(COUNTIF(A1:A4,"");"calculation impossible";SUM(A1:A4))

    cheers
    --
    The quality of the answer mostly depends on the clarity of the question, thank you!
    1
    1. Aztek33 Posted messages 553 Registration date   Status Member Last intervention   56
       
      Thank you for your response. However, I am facing a limitation because if the cells are not adjacent (E3, H3, M3, P3, R3), Excel tells me that I have entered too many arguments...

      It seems that it only accepts 3 non-adjacent cells...

      Do you have any idea?
      0
      1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453 > Aztek33 Posted messages 553 Registration date   Status Member Last intervention  
         
        Re
        Indeed, it's not the same question!
        =IF(OR(E3="",H3="",M3="",P3="",R3=""),"",E3+H3+M3+P3+R3)
        Cheers
        0