=ROUNDDOWN FUNCTION

Smurfit-Stone

Active Member
Joined
Dec 1, 2004
Messages
485
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
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
barry houdini said:
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,080
Members
412,566
Latest member
TexasTony
Top