Show Blank If Condition Met

    I would appreciate it a lot if someone could explain to me how I hide the value in the cell which a result is stored in when one of the two cells in the calculation is empty.


    For exaple:
    C1 should be blank if A1 or B1 is empty in this formula:
    =A1+B1


    Thanks in advance


    GZ

    Re: Hide value


    Thanks a lot.


    By the way is there a way to use it with this function

    =SUMIF(databas!A:A;C5;databas!B:B)



    C5 will always have value so the D5 should be blank if A:A or B:B has no value in the databas sheet

    Try Google your Thread Title choice (Hide value) and see just how selfish it is! This forum is all about sharing. Those who ask questions cannot share much, but they should at least try to give back by using a helpful and search friendly Title along with a well written description of the problem.


    Please do so in future, just as you agreed to in the rules when joining! Make no mistake, our rules here are enforced and are not hollow.


    Please read the Rules you agreed to when joining. In particular the point on Thread Titles. After you have done so please CLICK HERE and Private Message me or another mod royUK;Jack in the UK;Richie(UK);Dave Hawley;ByTheCringe2 with your acceptance, or non-acceptance of the rules and a suggested change for your thread title. Please also include a link to this Thread. You can copy this directly from the Address bar of your Browser. When this is done your thread will be re-opened.


    [COLOR="Red"]REMEMBER:[/COLOR] Your question Title must accurately and concisely describe your problem, NOT what you THINK is your answer and use only relevant keywords.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login