Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started