Conditional calculations

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

  • Posted 8 September 2017, 2:02 pm EST

    <p>Hi</p><p> </p><p>I saw some old posts where it seems that we could not force an empty cell.</p><p>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.</p><p>Is there any thing that could be done with newer versions?</p><p> </p><p>Regards <br></p>
  • Replied 8 September 2017, 2:02 pm EST

    <p>Hello, </p><p>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.</p><p> </p><p>Thanks,</p><p> </p>
  • Replied 8 September 2017, 2:02 pm EST

    <P>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.</P>
    <P>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.</P>
    <P>If you need a formula to produce a null value then there are a couple of other options to consider.</P>
    <P>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.</P>
    <P>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.</P>
Need extra support?

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

Learn More

Forum Channels