Solved

Calculate Less than or Greater than

  • 3 April 2019
  • 1 reply
  • 173 views

Badge +2

So I have a Reimbursement form where individuals will get reimbursed for Days they use Phone for work.  I am using a Repeating section in the form, I can calculate the number of days they use Phone. What I have having issues with is Calculating amount.  so if they use the phone <=10 days get $10 per day.  If it is >10 & <21 days they get $15  >20 they get $20.  So I used this calculated value and Variations of it but only thing I could get back is TRUE.  Total days <=10*10  or Total days(<=10*10) 

This is what I tried First Total days <=10*10||Total days>10&&<21*15||Total days>20*20  

What am I doing wrong?

icon

Best answer by shaunlub 4 April 2019, 04:28

View original

1 reply

Badge +11
I would suggest using a nested if statement...
If(Total days=<10,'10', If(Total days<20,'15','20'))
In words ->
If total is under/equal 10, result is 10
Otherwise, if total is under 20, result is 15
Otherwise, result is 20

Reply