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!”
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