Get instant live expert help on I need help with excel if 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

I need to write if S is blank then T but if not blank then S
Solved by V. U. in 15 mins
I need a formula that if C5 is blank returns 0 and if C5 is not blank it returns the result of B5-C5
Solved by V. C. in 25 mins
Is there a formula where I can format a column to be removed, if its reference is blank, but to stay if its value is not blank?
Solved by X. D. in 12 mins
In need a formula IF column D is not blank AND column G OR column I OR column J is blank THEN "Pending" IF column D is not blank AND column G OR column I OR column J is not blank THEN "Closed" I have tried COUNTIFS, IFS, and can't get this to work. I don't know what I am missing. Each column is a DATE as well. I was thinking If DATEVALUE like whatever the date is then yada yada, but I can't get this rationale to work in excel AT ALL. I'm at a lost.
Solved by A. L. in 15 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