I have two values and I want to add them together and apply a percentage increase to them, but with the command I’m using, it’s only applying the percentage increase to the second value, not the sum of the two.
I use a Spanish configured version of Calc, so here’s the command that I use:
=suma(X+Y/100*Z) (where X and Y are the two cells that I wish to add together and Z is the percentage as recorded in another sell).
Using this command, Calc is adding 20% to Y then adding the total of that to X. What I want it to do is add X and Y together then increase their total value by 20%.
Thanks in advance.