logic for field

[Former Member]

Hi,

I am having one field with name 'Book Value' in Invoice. Book value depends on Excise Number Range.

For example Excise Number Range is 1 - 100000. If Excise No falls between 1 and 50 the Book Value is 1 and If Excise No falls between 51 and 100 the Book Value is 2 and If Excise No falls between 101 and 150 the Book Value is 3 and so on . The book value gets incremented by 1 for the range of 50.

How can i code this. Please suggest.

Thanks

K Srinivas

[Former Member]

divide excise number by 50 then add 1 to the quotient u get. that will be the book value

[Former Member]

If Excise_No between 1 and 50.
Book_Value  = 1.
elseif Excise_No between 51 and 100.
Book_Value  = 2.
.
.
.and so on
ENDIF