Gerhardpet

asked on

# 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

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

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

That was easy. Thanks for your help!

else if {@TotalNet} > 1500 then 5

else 0