Re: [libreoffice-users] [3.5.3.2/Calc]Multiply percentage with fraction?

[Dan <elderdanlewis@gmail.com>]

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: users+help@global.libreoffice.org
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