## Show only integers, whole numbers without rounding

### Show only integers, whole numbers without rounding

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

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
FJCC
Moderator

Posts: 7492
Joined: Sat Nov 08, 2008 8:08 pm

### Re: Show only integers, whole numbers without rounding

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.7 Build 9800 on MacOS 10.14.6.   The locale for any menus or Calc formulas in my posts is English (USA). MrProgrammer
Moderator

Posts: 3953
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA