Why does it multiply correctly but not add?
Because it adds correctly. 25% = 0.25, if it's not specified what the percentage is being multiplied by. And in your case, it's not specified.
A more important question is, what are you using to calculate the formulas?!