Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
1  
Can you label the columns in the example, which is O, which is J,etc –  Akash Sep 7 '13 at 11:12
add comment

1 Answer

up vote 2 down vote accepted

Use the TRUNC function

=TRUNC(B1)

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

=TRUNC(B1/A1)

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
add comment

Your Answer

 
discard

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.