What I am trying to do is make a formula that meets the following:
IF the total is between 0-10000 then take the total and multiply it by .10
IF the total is more than 10000 then it equals 1000
IF the total is less than 0 then is equals 0
I am sure it is super easy and I am just missing a simple step.
Thank you
Bookmarks