Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.