Calculate a variable by many conditions

Hello everyone
I have a variable named 'c' and I need to calculate another variable named 'k' according to the following

If c < 100 then k=c
If c >=100 And c<200 then k=c -100
If c >=200 And c<300 then k=c-200
If c >=300 And c<400 then k=c-300
and so on ... till 5000

I know how to use IF and select case but I am searching for a better and easier way for that .. and I am sure there is a way
Thanks advanced for help

Hi,

To clarify, if c = 99, then k = 99; if c = 199, then k = -99; if c = 299 then k = -99?

Originally Posted by xlnitwit

Hi,

To clarify, if c = 99, then k = 99; if c = 199, then k = -99; if c = 299 then k = -99?

Hello xlnitwit for reply and I am sorry for my bad explanation. I have edited the first post .. It would be positive not negative

It appears you simply need

Please Login or Register  to view this content.

Originally Posted by xlnitwit

It appears you simply need

Please Login or Register  to view this content.

Thanks a lot for this simple and effective solution. I didn't think of it at all

Thanks a lot Mr Cytop for your solution too but I got the correct results from this line
k=c Mod 100