I have encountered this formula in a some software I'm reverse engineering:
NewAmount = ((SumofRates) * (1 - (1 - BPT_TAX)))
and I simplified it to
NewAmount = SumofRates * (1 - (1 - BPT_TAX))
and then I took it to this (is that my mistake?):
NewAmount = SumofRates * (1 - 1 - BPT_TAX)
I mean.. what is the point of the parenthesis if you're just doing subtraction, right? So this essentially is
NewAmount = SumofRates * (0 - BPT_TAX)
so does it equal
NewAmount = SumofRates * (-BPT_TAX)
I stopped for a second - that can't be right. I tried to do this in excel 1 - (1 - BPT_TAX)
and I always came up with BPT_Tax
as my final answer. So the parenthesis do mean something after all!
So then why wouldn't the developer just do :
NewAmount = SumofRates * BPT_TAX
in the original formula? Am I missing something here?