Int question

[arlene_fool]

Excel Workbook
	A	B
1		30-Dec-12
2	21-Jan-13	0
3		0.785714
Sheet1

Excel 2010

I want the number in b2 to be 1, shouldnt the int formula round up if the value is over 0.5? please help.

thank you

 

[MrKowz]

INT will grab the whole number associated with a decimal. You want to use =ROUND(B3,0)

 

[Jonmo1]

Nope,
INT returns the Integer of the value (the value to left of decimal point)
There is no rounding involved with INT.

If you want it rounded, use ROUND(B3,0)

This will round
.0 - .4999 Down
.5 - .9999 UP

 

[arlene_fool]

thank you

 

[Scott Huish]

There is rounding with INT, it rounds down to no decimal places.