If Statement containing a Sum —


If A1 contains Z, I want the sum of A2 and A3 If A1 contains S, I want 0 =IF(A1=”Z”,SUM(A2+A3),IF(A1=”S”,0,”0.00″))

via If Statement containing a Sum —

Advertisements