[Solved] Two separate functions in a cell

[Pinkmen]

Hello Calc users! I have a hectic problem but it seems fairly simple, I just don't know the language we are using here lol.

All I want to accomplish is to run a "=sumproduct" and after that subtract a value from another box. My code looks like this currently.
=Sumproduct();-A2. However it gives me the error:509.

I have also tried =sumproduct()&-a2
But that ends up saying "x - a2." I would like to search around for this problem, but i have no idea what this is even called in english.


Well I hope there is an actual solution to this! Hope yall the best day today!

[floris v]

If you want the difference of those two, you should use =Sumproduct()-A2 instead. That will give you a single value.

[Pinkmen]

Thank you!!