Conditional calculations

Posted by: quim on 8 September 2017, 2:02 pm EST

  • Posted 8 September 2017, 2:02 pm EST

    Hi

     

    I saw some old posts where it seems that we could not force an empty cell.

    The issue is that 0 is different from nothing. I have a particular situation where I just want to calculate if A >= B, if A < B the calculation doens't make sense and forcing a zero is not correct because the user will see it has a calculation result.

    Is there any thing that could be done with newer versions?

     

    Regards

  • Replied 8 September 2017, 2:02 pm EST

    Hello,

    You may set the Cell's Value to " "(empty String) to show an empty cell if you don't want a "0" to be displayed.

     

    Thanks,

     

  • Replied 8 September 2017, 2:02 pm EST

    quim,


    Spread uses a subset of Excel's formula syntax.  Excel's formula syntax does not provide any means for creating a formula result that is equivalent to a blank cell.


    DeepakSharma's suggestion of using "" value (empty string) may or may not work depending on you specific scenario.  A cell containing "" value (empty string) will in most cases display similar to a cell contain null value (blank cell).  However, "" value and null value are two different values and can produce differrent results when used in other formulas.


    If you need a formula to produce a null value then there are a couple of other options to consider.


    You could define a custom function that returns null (similar to how the built-in function TRUE() returns true).  Then you could use the custom function in your formulas.


    If your spreadsheet has a cell that will always be blank then you could use that cell in your formulas to produce a null value.  To make the formulas more readable, you could create a custom name that references the blank cell and then use the custom name in your formulas.


    Bobby

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels