if statement - Excel "IF" function. -
if want ask excel calculate in cell if 2 other cells have values in them, code? know calculate if single cell has value =if(a1=0,"",b1-b2)....but how add criteria 2 cells have value in them?
example a1 , b1 0:
=if(and(a1=0,b1=0),"",b1-b2)
Comments
Post a Comment