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.

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?

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

The formula in cell k3 gives a zero if the cell is

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!