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
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
