calculation between various conditions

[Ben Ball]

I have a situation as follows.

Ref

FieldA x FieldB = fieldC

I have values which range from 0 to 1000 as Field A

FieldB will calculate if:

values are between 0 to 1 I need to multiply fieldA by 250%

values are between 1 and 30 multiply fieldA by 200%

values are between 30 and 1000 multiply fieldA by 100%

but I can't seem to make this work.

I am not sure how to calculate if a number is bewtween 2 values... as detailed above.

TIA

[eos]

Define FieldC as

Let (



[

a = FieldA ;

b = FieldB ;

mp = case ( b <= 1 ; 2.5 ; b <= 30 ; 2 ; b <= 1000 ; 1 )

] ;



a * mp



)

[Ben Ball]

perfect. Thanks.