Formula Evaluate to Blank if Referenced Cell Blank

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