Skip to main content
B
bgarmann1-Visitor
1-Visitor
May 17, 2016
Solved

Problem with money

  • May 17, 2016
  • 8 replies
  • 4090 views

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 ?

Best answer by VladimirN

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

8 replies

W
Werner_E25-Diamond I
25-Diamond I
May 17, 2016

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

S
StuartBruff23-Emerald V
23-Emerald V
May 17, 2016

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

    F
    Fred_Kohlhepp23-Emerald I
    23-Emerald I
    May 17, 2016

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

    Oh, That's POOR!  🙂

    V
    ValeryOchkov24-Ruby IV
    24-Ruby IV
    May 17, 2016

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

      V
      VladimirN24-Ruby IVAnswer
      24-Ruby IV
      May 17, 2016

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

        B
        bgarmann1-VisitorAuthor
        1-Visitor
        May 18, 2016

        Thanks for the update. It's working fine now

        Terms & ConditionsAccessibility statement