5 Replies Latest reply on Dec 17, 2014 12:42 PM by jamesgibson_1

# if... then do the maths question

### Title

if... then do the maths question

### Post

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%

• ###### 1. Re: if... then do the maths question

Try:

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

• ###### 2. Re: if... then do the maths question

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?

• ###### 3. Re: if... then do the maths question

If I understand correctly, you want:

Case (

Entry < 5000 ; 0 ;

Entry > 20000 ; 1000 ;

Entry * .05

)

• ###### 4. Re: if... then do the maths question
Thanks so much, you're God.
• ###### 5. Re: if... then do the maths question

hi hiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiihhhhhhhhhhhhhhhhhhhhhhhhhhhhhiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii