My formula is ({Fee Before Disc} *Discount) - {Fee Before Disc}
Despite it being a positive number subtracting the discounted amount, it ends up being a negative number.
Example: 1800 -40% disc =1080 but it shows up as -1080?
Why would this generate a negative number? How can I fix this?
The way your formula is written would produce a negative number.
(1800 * .4) - 1800 = -1,080
You’ll want to rewrite your formula to this:
{Fee Before Disc} - ({Fee Before Disc} * {Discount})
You are brilliant! Thanks so much for helping me figure this out.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.