AboutPricing

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.
< Go Back

    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