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

2012-07-09 Thread Tinkerer
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:

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

2012-07-09 Thread Andreas Säger
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

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

2012-07-09 Thread Dan
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

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

2012-07-09 Thread Gilles
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:

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

2012-07-09 Thread Brian Barker
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