[3.5.3.2/Calc]Multiply percentage with fraction?

users
#1

Hello

The C1 column contains percentages, eg. "1,80%" while C2 contains rational
numbers, eg. "0,70".

I need to multiple C1 x C2, but Calc displays "#NAME?".

What should I do to perform this operation?

Thank you.

#2

Gilles wrote:

Hello

The C1 column contains percentages, eg. "1,80%" while C2 contains rational
numbers, eg. "0,70".

I need to multiple C1 x C2, but Calc displays "#NAME?".

What should I do to perform this operation?

Thank you.

--
View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438.html
Sent from the Users mailing list archive at Nabble.com.

       This is what I did. I right clicked the A of column A and selected Format cells. I selected percentage. Then I used this procedure to format Column B as a number with 2 decimal places. I entered 1.25 in cell A1 (1.25%) and entered 80 in cell B1 (80.00). In cell C1 I entered "=A1*B1. Cell C1 shows 1 as the answer.
      I'm not sure what the error is, but I will suggest something. Have you formatted your C1 and C2 columns correctly?
      I noticed another thing. When I format both columns as text and enter 1.25% in A1 and 80.00 in B1, I still get 1 as my answer.

--Dan

#3

It worked for me, = 1.26
In the multiply C1 by C2 cell you must have hit the function icon and not
the equals icon.
This would Sum the two in the absence of any chosen function.

Tink.

#4

Am 09.07.2012 14:54, Dan wrote:

Have you formatted your C1 and C2 columns correctly?

The OP gets the #NAME error.
What is a correctly formatted cell?
Can you demonstrate us a single case where any formatting attribute has any influence on the cell value?

#5

Andreas Säger wrote:

Am 09.07.2012 14:54, Dan wrote:

Have you formatted your C1 and C2 columns correctly?

The OP gets the #NAME error.
What is a correctly formatted cell?
Can you demonstrate us a single case where any formatting attribute has any influence on the cell value?

      Probably not, but neither have you made any suggestions nor asked any questions. So, the OP does not receive any benefit from you either.

      Probably more to the point, Gillas, would you please tell us what you did to get the #Name error? What formula did you use?

--Dan

#6

Thanks everyone for the help. Turns out the error was due to my using a "."
instead of "," as decimal separator.

This works for me...

"=$C4 * 0,845"

... while this doesn't

"=$C4 * 0.845".

#7

[Shoots hand into the air.] Oh, sir! Please, sir! I know, sir!

If you enter, say "1.23%" into a cell with numeric or general formatting, you get a number with the expected value and expressed as a percentage. But if the cell is previously formatted as text, you get the text string "1.23%", which is, of course, different. In contexts where the numerical value of a text string is taken as zero in a calculation, there will indeed be a difference.

Now you'll say that this sort of formatting in advance was not what you meant, and that may be so. But it *is* what your questioner may have meant.

Brian Barker