Get instant live expert help on count if cell is not blank

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hi, I use the following formulas to count the number of days between two dates, and if one column is blank, to show a blank cell, otherwise the number of days, on in a nearby cell "Not Received". =IF(H197="","",IF(C197="",TODAY(),C197)-H197) =IF(H197="","Not Received","") I would like to show something like "Not Received" if the cell is returned blank. I have got this working in an adjacent cell, but would like to combine the two formulas to show in the same cell. Hope this makes sense? Please could someone help me combine the two formulas to show the desired result, or is it not possible? Kind regards, Stephen
Solved by S. J. in 29 mins
0 blank =IF(D4>C4,1,"") Why does the 3rd cell give me 1 when the blank cell is not greater than the 0 cell?
Solved by G. H. in 26 mins
When using an IF-Than Formula, how do you get the False Value to Turn a Cell Blank? I have been using "", but then it registers in COUNT Formulas. Is there a False Result to just keep the Cell Blank, so it does not mess up other formulas performing on it?
Solved by B. A. in 23 mins
Google Sheets: Example: Cell B1 will format as Yellow Background If the following conditions: A1 is not blank B1 is blank
Solved by G. H. in 17 mins
I want to see if theres a way i can make a cell go blank or make it equal to 0 when another cell is not blank
Solved by M. H. in 26 mins