dimanche 7 juin 2020

I want to use 2 formula in one cell. If one formula returns 0 value, I want to use the other formular to return value

what I want to perform is: if "SUMIF('NJ'!A:A,C3,'NJ'!I:I)≠0", return the value of the "SUMIF('NJ'!A:A,C3,'NJ'!I:I)" if "SUMIF('NJ'!A:A,C3,'NJ'!I:I)=0", I want to use this formula "SUMIF('QJ'!A:A,C5,'QJ'!AC:AC)" to return the value. How do I put all this formula in one single cell? I just can't find the right answer on google, please help me ㅠ

Aucun commentaire:

Enregistrer un commentaire