HI
i want to enter data in one coloum as
0+250
2+250
3+750
as a road length marking. i want to add all this three values.
if value after + operator increase 1000 the value should be added to the value before + operator
for Example for the above values if i add them answer should be
6+250
As 250+250+750=1250
so i add one in value before +operator so that is 6.
please give me some suggestion or Formula for this Problem.
Bookmarks