• Omega_Haxors@lemmy.ml
    link
    fedilink
    English
    arrow-up
    1
    arrow-down
    1
    ·
    edit-2
    9 months ago

    Five isn’t mathematically a round-up number, we just arbitrarily decided to round up because numbers were used in merchant contexts where obviously you want to get people to pay more for their stuff than less. As for solutions I just introduce a tiny error because it’s genuinely less effort than constantly referencing a cell and locking it so that it won’t run away if you drag it around. It’s a very easy to forget a lock.

    • bstix@feddit.dk
      link
      fedilink
      English
      arrow-up
      1
      ·
      9 months ago

      Name the cell “myPi” and use that instead of the Pi function.

      • Omega_Haxors@lemmy.ml
        link
        fedilink
        English
        arrow-up
        2
        arrow-down
        1
        ·
        9 months ago

        That’s a pretty high-q move. I’ve moved to LibreOffice which does Pi properly, but i’ll keep that in mind next time I need a static data reference.