cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:

1-Newbie

## Problem with money

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
23-Emerald IV
(To:bgarmann)

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

8 REPLIES 8
24-Ruby IV
(To:bgarmann)

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

23-Emerald II
(To:Werner_E)
 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

23-Emerald I
(To:StuartBruff)

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

Oh, That's POOR!  🙂

24-Ruby IV
(To:StuartBruff)
 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 😞

7-Bedrock
(To:StuartBruff)

24-Ruby II
(To:bgarmann)

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

23-Emerald IV
(To:bgarmann)

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

1-Newbie