=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 durgadurgamanoha...@gudalur.net To:users@libreoffice.org Copies to:tanstaafltansta...@libertytrek.org Subject:Re: [libreoffice-users] Calculating the month number Send reply to:users@libreoffice.org 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 users+h...@libreoffice.org 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 users+h...@libreoffice.org 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
