Formula Evaluate to Blank if Referenced Cell Blank

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    I was wondering is there a way to have a forumla leave a blank result if one of the cells in the formula were blank?? Thanks for any help your can give.

    Re: Hiding formulas


    You could use an if formula and make [if answer is zero or less than value egauals "".]
    Or select tools>options>and uncheck zero values. But that does the whole page.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

    Re: Hiding formulas


    Put a value in cell a1 like 5
    Put this =IF(A1>10,A1,"") in b1
    Its broke apart by the commas first is your equation A1 value is greater than 10 then Your answer if True A1 Value Then False ""
    Hope that explains it

    [SIZE=2]I should change my name to STUMBED![/SIZE]

    Re: Hiding formulas


    Also notice on your formula bar the "="
    Click on that and you can select the formula you want to use.
    Read through the descriptions and play around with the formulas it will open a whole new world.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

    Re: Formula Evaluate to Blank if Referenced Cell Blank


    No problem, so many people help me out its nice to help somebody else.

    [SIZE=2]I should change my name to STUMBED![/SIZE]

Participate now!

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

Register Yourself Login