Help with excel formula. You will notice that cell B6 is blank. The formula in c

Question

Help with excel formula. You will notice that cell B6 is blank. The formula in cell k3 gives a zero if the cell is blank. Is there a way to tell the formula to stay blank instead of giving a zero if there is a spot that is blank in the table?

12/2/2017 Gen New Gen - New Gen New Gen New 12/3/2017 12/4/2017 Gen New Gen Ne A/L-Intent Gen New Gen New Gen - New Gen-Action Needed Gen New Gen Supervisor Review A/L - Intent 12/5/2017 Gen TO BE CLOSED Gen TO BE CLOSED Gen TO BE CLOSED L- Intent Lien 12/6/2017 12/8/2017 Gen TO BE CLOSED L- Intent Lien Gen Investigation Gen Action Needed 12/7/2017 Name 2 Towanna Knight 3 Magen Hardee 4 Melissa Williams 5 TIFT123456 6 Marlo Sarkadi 7 Mary Tomlinson Gen Action Needed L-Intent - Lien L Intent - Lien Gen Supervisor Review Gen Investigation Gen Investigation Gen Investigation Gen Supervisor Review Gen Action Needed Gen - Action Needed Gen - Action Needec L- Legal Error L- Legal Error L - Intent Lien Gen Batch Patient Contact Letter Gen - Pending Patient Contact L - Intent Lien Gen New Gen TO BE CLOSED 10 Marlo Sarkadi 1/0/1900 12/2/2017 12/3/2017 13 Gen Action Needed 12/4/2017 12/5/2017 15 Gen - Batch Patient Conta 12/7/2017 16 Gen - Pending Patient Con 12/8/2017 12 Gen New 14 L Legal Error

Explanation / Answer

Use if condition on your formulae : if{ condition of blank, blank is found ," ")

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.