I have been looking for a formula that will produce a blank cell under certain circumstances. I have found some formulas for this, but not to the level of detail I need it. I've tried "ISBLANK, "SUMIF" and "IF" and I'm stuck.
I need D1 to produce a blank cell if A1 and B1 and C1 are blank. If there is at least one value in A1 or B1 or C1 then I want D1 to produce the sum of A1:C1.
Any help would be great. Thanks.
I need D1 to produce a blank cell if A1 and B1 and C1 are blank. If there is at least one value in A1 or B1 or C1 then I want D1 to produce the sum of A1:C1.
Any help would be great. Thanks.