if... then do the maths question

Hi, everyone, here's my problem:

If the field data entry is smaller than 5000 then the result is 0, if greater then process the calculation... say + 5%

Thanks in advance.

Try:

Case ( Entry < 5000 ; 0 ; Entry * 1.05 )

Case ( Entry < 5000 ; 0 ; Entry * .05 )

Thank you, it did work. But I face any other problem, since I also want something like this:

Case ( Entry > 20000 ; 1000 ; Entry * .05 )

How can I combine this two script and result in a single field?

If I understand correctly, you want:

Case (

Entry < 5000 ; 0 ;

Entry > 20000 ; 1000 ;

Entry * .05

)

hi hiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiihhhhhhhhhhhhhhhhhhhhhhhhhhhhhiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii

Try:

Case ( Entry < 5000 ; 0 ; Entry * 1.05 )