On 25 May 2011 at 16:07, Tom Davies wrote: Date sent: Wed, 25 May 2011 16:07:06 +0100 (BST) From: Tom Davies <[email protected]> Subject: Re: [libreoffice-users] Calculating the month number To: [email protected] Send reply to: [email protected]
> 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". I had actually done that, but copied the contents of an earlier cell? But, it actually would only be an issue if it was exactly 5/1/2011 at exactly midnight, since even one second after that would be greater than. If comparing to a cell with a date value, it might have the zero time value, so definitately the >= should be used. > > 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 +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:[email protected] mailto:[email protected] http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 10793120.868193 | EINSTEIN 5924368.650851 ROSETTA 3179738.194080 | ABC 5978342.567696 -- 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
