G
Guest
I want to write a simple formula. In column A and B I have values. In column
C I write my formula. I want to check if A and B anre not zero and if they
are both not zero I want to take A minus B. Now I tried writing it like this:
=IF((A22<>0 & B22<>0);A22-B22;"-")
It does not work. It taks A-B regardless of their values. Please help me
with this forumla!c Thanks alot!
C I write my formula. I want to check if A and B anre not zero and if they
are both not zero I want to take A minus B. Now I tried writing it like this:
=IF((A22<>0 & B22<>0);A22-B22;"-")
It does not work. It taks A-B regardless of their values. Please help me
with this forumla!c Thanks alot!