Re: [libreoffice-users] Re: [3.5.3.2/Calc] Multiply percentage with fraction?
At 18:55 09/07/2012 +0200, Andreas Säger wrote: At 08:54 09/07/2012 -0400, Dan Lewis 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? [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 -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?
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". -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438p3994566.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?
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 -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?
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? -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: [3.5.3.2/Calc]Multiply percentage with fraction?
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. -- View this message in context: http://nabble.documentfoundation.org/3-5-3-2-Calc-Multiply-percentage-with-fraction-tp3994438p3994492.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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