for, if, and, end if

[intothewild]

im trying to achieve the following

if val a = val b and val a > 5000 then val q = val q
else
if val a = val b and val a is between 1000 and 5000 then val q = val q - 0.25
else
if val a = val b and val a is between 500 and 1000 then val q = val q - 0.5
else
if val a = val b and val a is between 250 and 500 then val q = val q - 0.75
else
if val a = val b and val a < 250 then val q = 0


the first and last statements seem to work but the middle three wont which seems due to the double Ands
how do i write the properly and is there a way to write the code more economically?

Please Login or Register  to view this content.

[TMS]

I suggest you post a sample workbook with some typical data, the code and instructions on how to make it work/fail.


Regards, TMS

[Mad-Mizer]

You need to add underscores when using two lines for one line of code:

Please Login or Register  to view this content.

Now, I don't know if this actually solves your logical problems but...