simple calculation

[paul_apted]

hello ,

this is what i am trying to do . i have a field with a value list of 1-50 .depending on what value i choose i want another field to divide that by 8 and then round it up to the nearest 1

eg 8 =1 good

12= 1.75 bad ,i would like 9 thru 15 to =2

and so on

i can get the calculation to give me the BAD results but not the GOOD

i am sure it is dead simple

thanks

paul Apted

[BobWeaver]

Int((TheNumberField1 -1)/8)+1