Problem with money

[bgarmann]

Hello,

I have a problem with this sheet.

I am trying to multiply an add some things with each other. But i get a error.

Can you guys help me ?

[Werner_E]

The error message is quite informative, I think.

You multiply two variables of unit "Money" and so you get a variable of unit "Money"squared, whatever that may be. You see the €² in your screenshot?

Then you try to add simple "Money" to that "Monay²" - this has to fail.

Think of meter.

Can you add 2 m² + 3 m ? Sure not - you can not add an area and a length. What should the outcome be?

The same applies to € + €² - they are not compatible and Prime correctly refuses to add them.

WE

[StuartBruff]

Werner Exinger wrote:

The error message is quite informative, I think.

You multiply two variables of unit "Money" and so you get a variable of unit "Money"squared, whatever that may be. You see the €² in your screenshot?

Then you try to add simple "Money" to that "Monay²" - this has to fail.

Think of meter.

Can you add 2 m² + 3 m ? Sure not - you can not add an area and a length. What should the outcome be?

The same applies to € + €² - they are not compatible and Prime correctly refuses to add them.

WE

So, it's true.  Money really is the square root of all €vil?

Stuart

[Fred_Kohlhepp]

"So, it's true.  Money really is the square root of all €vil?"

Oh, That's POOR!  🙂

[Werner_E]

So, it's true.  Money really is the square root of all €vil?

Concerning the €uro you are not far from the sad truth, I guess 😞

[nas0k]

[ValeryOchkov]

I have a problem with money too - I would like to have more then I have

[VladimirN · Accepted solution]

The variant of the solution in an attachment will suit you?

[bgarmann]

Thanks for the update. It's working fine now