[users] Re: Question about Calc

2007-10-26 Thread Himanshu Ardawatia
] To: users@openoffice.org Date: Sun, 14 Oct 2007 12:40:12 -0600 Subject: Re: [users] Question about Calc On Sun, 14 Oct 2007 20:33:54 +0200 Himanshu Ardawatia [EMAIL PROTECTED] wrote: Is there any configuration in calc that can help me configure it for not considering any decimal number

Re: [users] Re: Question about Calc

2007-10-26 Thread Harold Fuchs
On 26/10/2007, Himanshu Ardawatia [EMAIL PROTECTED] wrote: And I tried all the options I could think of : The only ones that worked for me were : 1. As some of you suggested, writing a number by placing a '0' at the end : eg., instead of writing it as 24.9 write it as 24.90 and it

Re: [users] A question about Calc

2007-10-13 Thread Victor Domingos
Hi! I've been trying the method you suggested, but there seems to be something wrong. I am trying to send a .ods attached with this e- mail, I don't know if the mailing list allows this... I appreciate your help. Thanks, Victor Domingos http://lojamac.com/blog Em 2007/10/12, às

Re: [users] A question about Calc

2007-10-13 Thread Harold Fuchs
In general this list doesn't allow attachments through. Yours didn't make it. The best way to share files with us is to put them on a web page somewhere. If you don't have your own you can use www.mytempdir.com for free. Just remember to tell us the reference number that the site generates for

Re: [users] A question about Calc

2007-10-12 Thread Victor Domingos
Em 2007/10/12, às 18:54, Brian Barker escreveu: I imagine that you mean the SUMIF() function rather than COUNTIF(), but - as you have discovered - it is difficult to see how you can combine two conditions with SUMIF(). There is a way of achieving what you need using SUM(), and it is

Re: [users] A question about Calc

2007-10-12 Thread Brian Barker
At 15:53 12/10/2007 +0100, Victor Domingos wrote: I have a table where column B is storing dates and column C is storing money values referring to those dates. In another table, I would like to sum the money values for each week. I have been trying to accomplish this by creating a table with

[users] A question about Calc

2007-10-12 Thread Victor Domingos
Hi! I have a question about a formula in Calc. I hope there is someone who can help me... Here it goes. I have a table where collumn B is storing dates and collumn C is storing money values referring to those dates. In another table, I would like to sum the money values for each week. I