Rounding the value

[arunakumari02]

I have a problem in rounding the value.

intMonthToMove = 1,2,3,4..............................200

newvalue = VBA.Round(Monthe / 12) + 1 (This statement doesnot work as below)


I need to have newvalue in this way:

Month newvalue
1.....12 1
13.....24 2
25.....36 3
37.....48 4
...etc

Any hints?

 

[Brianwarnock]

How about Int((month-1)/12)+1

Brian

 

[arunakumari02]

It worked finally.

Thanks

 

[Brianwarnock]

Didn't see any negatives in the first post!! Try to give the helpers all the info then they don't get frustrated =Int(month/12) works for negative so select the required formula with an If month<0 type expression.

Brian

 

[Brianwarnock]

An explanation please.

Brian