Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a formula(=O6/J6) which resulting 11.9655. But after reducing decimal it's showing 12. I want to display only 11 and it should be without decimal.

It should be look like this:-

 |Box qnty     |    Stock|  Stock as Box | Stock(as pcs) not full box one|
 |     200     |     2570|           12  |              170              |
 |    1200     |     3700|           3   |              100              |
 |    1300     |     4800|           3   |              900              |
share|improve this question
Can you label the columns in the example, which is O, which is J,etc – Akash Sep 7 '13 at 11:12
up vote 3 down vote accepted

Use the TRUNC function


Assuming the 1st 2 columns in your example are provided data, and the next 2 are calculated and that the 1st cell of data resides as A1, for stock as box, you can use


and for

Stock(as pcs) not full box one

you can use =B1-A1*C1

share|improve this answer
But i have another cell with below formula which now showing 0 =MOD(P6,1)*J6 @Akash – Rono Charlson Sep 7 '13 at 10:50
@RonoCharlson In the example, which is the calculated field and which is already provided? – Akash Sep 7 '13 at 11:11
@RonoCharlson You can use =INT(stock/box_qty) as well. Also =MOD(x,1) returns the remainder after divided by 1. Since everything divisible by 1 the remainder is always 0. What are you trying to achieve? Please provide more excel sheet with more details. – Darius Sep 7 '13 at 11:30
Akash already solved my problem and i am happy with his answer. Thanks to you also for trying to solve my question. @Darius – Rono Charlson Sep 7 '13 at 11:42

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .