Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Financial Modelling Model Design And Best Practices Using Excel And VBA

Authors: Michael Rees

1st Edition

111890401X, 978-1118904015

More Books

Students also viewed these Finance questions