=ROUNDDOWN FUNCTION

[Smurfit-Stone]

Hello, I have a column with a formula (F2/360) I now would like to incorporate the rounddown function to this.....how can I do it. The example of rounddown I found in HELP is (rounddown(A2,0), how do I combine the two formulas? Thanks

 

[barry houdini]

simply

=rounddown(F2/360,0)

or you could use

=INT(F2/360)

 

[Aladin Akyurek]

simply

=rounddown(F2/360,0)

or you could use

=INT(F2/360)

The 2nd would yield undesirable results with negative numbers. TRUNC instead of INT if such is wanted.