Hey community!
I've got a rather short and quick question:
Is there a possibility to round up a result of a calculation in a spreadsheet, just like Excel's "ROUNDUP" command?
I didn't see any in the documentation but I could really make use of this.
Best regards!
[Solved] Spreadsheet Commands - "roundup" ?
Forum rules
and Helpful information
and Helpful information
IMPORTANT: Please click here and read this first, before asking for help
Also, be nice to others! Read the FreeCAD code of conduct!
Also, be nice to others! Read the FreeCAD code of conduct!
[Solved] Spreadsheet Commands - "roundup" ?
Last edited by M_W on Thu Aug 13, 2020 7:55 pm, edited 1 time in total.
Re: [Solved] Spreadsheet Commands - "roundup" ?
Thx @bance
I dug through that exact page twice, but didn't know where to look and for some reason didnt realize the page even says "These functions for rounding, truncation and remainder are supported:" and that I had to unfold the list.
So thanks for your help.
Should anyone else use the search bar asking this exact question, the formula for rounding up to enter in a cell is:
=ceil(cellreference)
That's it.
Simple as that.
Question solved, I'll return to learn how to create fences and stuff using spreadsheets.
I dug through that exact page twice, but didn't know where to look and for some reason didnt realize the page even says "These functions for rounding, truncation and remainder are supported:" and that I had to unfold the list.
So thanks for your help.
Should anyone else use the search bar asking this exact question, the formula for rounding up to enter in a cell is:
=ceil(cellreference)
That's it.
Simple as that.
Question solved, I'll return to learn how to create fences and stuff using spreadsheets.
Re: [Solved] Spreadsheet Commands - "roundup" ?
When you're done at your leisure, do you mind posting a separate thread in the User Showcase subforum showcasing your work?
Alone you go faster. Together we go farther
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
Please mark thread [Solved]
Want to contribute back to FC? Checkout:
'good first issues' | Open TODOs and FIXMEs | How to Help FreeCAD | How to report Bugs
Re: [Solved] Spreadsheet Commands - "roundup" ?
Yeah I had to look a couple times before I realized there was an unfold...not immediately obvious, IMHO.
Star Trek II: The Wrath of Khan: Spock: "...His pattern indicates two-dimensional thinking."