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

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

Problem with money

bgarmann
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

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

View solution in original post

8 REPLIES 8

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
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

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

Oh, That's POOR!  🙂


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 😞

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

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

Thanks for the update. It's working fine now

Top Tags