Hi :) A > instead of the 2nd = seems to work. eg =IF(NOW()>DATE(2011,5,1),1000000,0)
Although you might need to change the 2011,5,1 to 2011,5,0 otherwise the 1st of the month might not be included. Perhaps =IF(NOW()>=DATE(2011,5,1),1000000,0) would be better as it is "greater than or equal to". Regards from Tom :) ________________________________ From: Michael D. Setzer II <[email protected]> To: [email protected] Sent: Wed, 25 May, 2011 15:49:18 Subject: Re: [libreoffice-users] Calculating the month number =IF(NOW()=DATE(2011,5,1),1000000,0) If the comparison is with the May 2011, instead of just being later than May. Since it is now past May 1, 2011, the same could be done in reference to a cell with a date value. So, instead of now(), it could be a reference to a cell with a date in it, or use datevalue if it is a string. On 25 May 2011 at 20:03, Manoharan Durga wrote: Date sent:Wed, 25 May 2011 20:03:36 +0530 From:Manoharan [email protected] To:[email protected] Copies to:[email protected] Subject:Re: [libreoffice-users] Calculating the month number Send reply to:[email protected] It is just =IF(MONTH(cellreference)5,1000000,0) replace cellreference with the cell address where May 2011 is stored. If you want the formula to automatically evaluate it based on today's date, then you can make it like below : =IF(MONTH(TODAY())5,1000000,0) Hope this helps On Wednesday 25 May 2011 07:49 PM, Tanstaafl wrote: Hi all, I'm trying to do a simple calculation: If the current month is May 2011 or later, 1,000,000, otherwise, 0 I tried: =IF(MONTH(5),1000000,0) Which obviously doesn't work... Is there an easy way to do this? -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
