a value in a cell

[baalim]

In Excel l have a cell that has a verbal value say 200. I add numbers to this value on daily badis. Example today I add 20 tomorrow I may add 35 and the other day I add 50..etc. until it reaches a total 100 added to the value, so it becomes 300 the I need it tells me done then it starts counting again from 300 until reaching 100 to become 400 telling me done and so on… Is there a formula in excel narrates and gives this result…

 

[mrshl9898]

Can you show an example of what it currently looks like and what you want to see.

If you are just changing the one cell VBA may be the solution:

Sub flag100()

Dim myval As Long
Dim addval As Long
Dim myint As Long
Dim myint2 As Long


myval = Range("B2").Value 'update as needed
addval = InputBox("Add value to Cell")

Range("B2").Value = addval + myval

myint = Int(myval / 100)
myint2 = Int((myval + addval) / 100)

If myint <> myint2 Then
MsgBox "Past 100"
End If

End Sub

If you keep adding values in different cells then a formula might be more suitable.

 

[baalim]

Thanks Dear Friend,
- I keep adding values in different cells (not one cell e.g. B2, B3, B4, B5 and B6 only)
- I kindly need “Past 100” to be written beside the cell B2 that Past 100 written in cell C2 and on for the other.
- The total 100 should be added exactly to the value whatever it is like 220 when 100 added to it becomes 320 (not 80 to be 300) the 100 is added on daily basis not in one time.

Please see table:

B2	C2
220	NOT YET
320	PAST 100
150	NOT YET
360	PAST 100
510	NOT YET

<tbody>
</tbody>

Can you show an example of what it currently looks like and what you want to see.

If you are just changing the one cell VBA may be the solution:

Sub flag100()

Dim myval As Long
Dim addval As Long
Dim myint As Long
Dim myint2 As Long


myval = Range("B2").Value 'update as needed
addval = InputBox("Add value to Cell")

Range("B2").Value = addval + myval

myint = Int(myval / 100)
myint2 = Int((myval + addval) / 100)

If myint <> myint2 Then
MsgBox "Past 100"
End If

End Sub

If you keep adding values in different cells then a formula might be more suitable.

 

[baalim]

Thanks Dear Friend,
- I keep adding values in different cells (not one cell e.g. B2, B3, B4, B5 and B6 only)
- I kindly need “Past 100” to be written beside the cell B2 that Past 100 written in cell C2 and on for the other.
- The total 100 should be added exactly to the value whatever it is like 220 when 100 added to it becomes 320 (not 80 to be 300) the 100 is added on daily basis not in one time.

Please see table:

B2	C2
220	NOT YET
320	PAST 100
150	NOT YET
360	PAST 100
510	NOT YET

<tbody>
</tbody>

 

[mrshl9898]

=IF(B3="","",IF(INT(B2/100)<>INT(B3/100),"PAST 100","NOT YET")) in C3 copied down