Crystal formula

I'm sure this is a simple formula but I can't figure it out

If the amount is greater or equal than 1,500 and less then 4999.99 it should be 5
If the Invoice amount is greater or equal than 5,000 it should be 10

Here what have which only works for the first condition
if {@TotalNet} >= 1500 then 5
else if {@TotalNet} > 5000 then 10
else 0
LVL 1
GerhardpetAsked:
Who is Participating?
 
SharathData EngineerCommented:
Or

if {@TotalNet} >= 5000 then10
else if {@TotalNet} >= 1500 then 5
else 0
0
 
SharathData EngineerCommented:
if {@TotalNet} >= 5000 then10
else if {@TotalNet} > 1500 then 5
else 0
0
 
GerhardpetAuthor Commented:
That was easy. Thanks for your help!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.