Help Understanding Formula with INT

[adamuce]

Hello Guys:

I am trying to understand the INT formula used in this equation. I have attached the excel sheet and the photo here (the emboldened part of the formula)

Thanks in advance

 

[chirayu]

attached breakdown

 

[adamuce]

Many thanks Chirayu...

I understand that it is also doing a bracket of 5.
However what if the bracket was 10?

 

[pecoflyer]

Excel has an "evaluate formula" function which will allow you to see, step by step how a formula works

 

[chirayu]

if you want a bracket of 10 then just change the 5 to a 10 for the divide/ multiply bits

 

[adamuce]

if you want a bracket of 10 then just change the 5 to a 10 for the divide/ multiply bits

thanks again mate you are a star! For my own understanding why did they subtract "1" and add "1" again?

Can anyone recommend an easy website to understand the INT function in my example?

 

[bosco_yip]

1] Your formula is targeted to round number up to nearest multiple of 5

Here is a simplified formula instead

=CEILING(2018-A2,5)+A2

2] For a multiple of 10 just change 5 to 10 as in :

=CEILING(2018-A2,10)+A2

Regards
Bosco

 

[adamuce]

1] Your formula is targeted to round number up to nearest multiple of 5

Here is a simplified formula instead

=CEILING(2018-A2,5)+A2

2] For a multiple of 10 just change 5 to 10 as in :

=CEILING(2018-A2,10)+A2

Regards
Bosco

Another new formula! WOW! thanks alot

 

[Peter Bartholomew]

How about
= MOD( -age, 5 )
where 'age' refers to column B.
That is, the number of years to go before the age reaches the next multiple of 5. If you want a bracket of 10
= MOD( -age, 10 )