Help with tracking

[AndrewD04]

Hi, firstly thank you for any help.
I am building a tracker that I need help with a formula I want a cell to increase by one for every 5 increment in another cell.

 

[Trouttrap2]

Here is what i came up with.
Excel 2010#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">

	A	B
1	Number	Increment
2	3	0

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col><col></colgroup><thead>
</thead><tbody>
</tbody>

#DAE7F5 ;color: #161120">Sheet2​

#FFFFFF " >

Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120"> Cell Formula #DAE7F5 ;color: #161120">B2 =INT(A2/5) <thead> </thead><tbody> </tbody> I guess my HTML maker isn't working.....

<tbody>
</tbody>

 

[AndrewD04]

Here is what i came up with.
Excel 2010#FFFFFF ;border: 1px solid;border-collapse: collapse; border-color: #BBB">#DAE7F5 " />#DAE7F5 ;text-align: center;color: #161120">

	A	B
1	Number	Increment
2	3	0

<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col><col></colgroup><thead>
</thead><tbody>
</tbody>

#DAE7F5 ;color: #161120">Sheet2​

#FFFFFF " >

Worksheet Formulas#FFFFFF ;border-collapse: collapse; border-color: #BBB">#DAE7F5 ;color: #161120"> Cell Formula #DAE7F5 ;color: ">B2 =INT(A2/5) <thead> </thead><tbody> </tbody> I guess my HTML maker isn't working.....

<tbody>
</tbody>

Perfect ? thank you

 

[AndrewD04]

Does anyone know how to carry over a number from one sheet to another for example.

I have a cell increasing ( C2)and another C3 which adds 1 for every 5 in cell C2 however I want it to carry over anything out of 5 on to another sheet so if there is 12 it will carry over the 2

 

[Trouttrap2]

I think this is what you are wanting?

=MOD(C2,5)