Show only integers, whole numbers without rounding

Discuss the spreadsheet application

Show only integers, whole numbers without rounding

Postby szkodnik2103 » Fri Apr 12, 2019 10:38 pm

Hi guys,

I am quite new in openoffice world but so far i was handle to do everything by my self. Now im struggling with some problem about numbers. I would like to make simple mathematical operation between two cells. In one of them(e.g. A1) i want to keep my account balance and the other one (A2) i want to keep price of some item. I would like to calculate how many items i can get (in A3 cell). Let's say that item is TV or PS4 or whatever you can't divide. If im gonna divide A1/A2 im gonna get number of items i can buy. But if my A1 is 1366,2 and A2 is 10 the result of that calculation in A3 would be 136,62. Even if i change decimal places to 0 it gonna round up my calculation and shows me 137. And there is my question. How to show only full numbers without rounding them up. I want to get 136 in A3 cell.

Im sorry for my English and i hope that some of you gonna understand my goal. I would appreciate all provided help. Thank you
OpenOffice 6.2.2.2 on Windows 10
szkodnik2103
 
Posts: 1
Joined: Fri Apr 12, 2019 10:10 pm

Re: Show only integers, whole numbers without rounding

Postby FJCC » Fri Apr 12, 2019 10:58 pm

Try a formula like
Code: Select all   Expand viewCollapse view
=FLOOR(A1/A2;1)

If you ever need to use FLOOR with negative numbers, check out the Help since there are two ways the answer can be calculated.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7258
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Show only integers, whole numbers without rounding

Postby MrProgrammer » Fri Apr 12, 2019 11:50 pm

szkodnik2103 wrote:In one of them(e.g. A1) i want to keep my account balance and the other one (A2) i want to keep price of some item. I would like to calculate how many items i can get (in A3 cell).
OpenOffice Help wrote:QUOTIENT(Numerator; Denominator)
Returns the integer part of Numerator divided by Denominator.
In cell A3: =QUOTIENT(A1;A2)

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3810
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Calc

Who is online

Users browsing this forum: No registered users and 39 guests