[Solved] Spreadsheet Commands - "roundup" ?

Post here for help on using FreeCAD's graphical user interface (GUI).
Forum rules
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!
Post Reply
M_W
Posts: 39
Joined: Sun May 12, 2019 12:53 pm

[Solved] Spreadsheet Commands - "roundup" ?

Post by M_W »

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!
Last edited by M_W on Thu Aug 13, 2020 7:55 pm, edited 1 time in total.
Bance
Veteran
Posts: 4186
Joined: Wed Feb 11, 2015 3:00 pm
Location: London

Re: Spreadsheet Commands - "roundup" ?

Post by Bance »

See Expressions

General Mathematical Functions

Rounding
M_W
Posts: 39
Joined: Sun May 12, 2019 12:53 pm

Re: [Solved] Spreadsheet Commands - "roundup" ?

Post by M_W »

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.
User avatar
Kunda1
Veteran
Posts: 13434
Joined: Thu Jan 05, 2017 9:03 pm

Re: [Solved] Spreadsheet Commands - "roundup" ?

Post by Kunda1 »

M_W wrote: Thu Aug 13, 2020 8:08 pm I'll return to learn how to create fences and stuff using spreadsheets.
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
drmacro
Veteran
Posts: 8866
Joined: Sun Mar 02, 2014 4:35 pm

Re: [Solved] Spreadsheet Commands - "roundup" ?

Post by drmacro »

M_W wrote: Thu Aug 13, 2020 8:08 pm and that I had to unfold the list.
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."
Post Reply