Re: [libreoffice-users] Calculating the month number

On 25 May 2011 at 16:07, Tom Davies wrote:

Date sent:              Wed, 25 May 2011 16:07:06 +0100 (BST)
From:                   Tom Davies <tomdavies04@yahoo.co.uk>
Subject:                Re: [libreoffice-users] Calculating the month 
number
To:                     users@libreoffice.org
Send reply to:          users@libreoffice.org

> 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 <mikes@kuentos.guam.net>
> To: users@libreoffice.org
> 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 Durgadurgamanoharan@gudalur.net
> To:users@libreoffice.org
> Copies to:Tanstaafltanstaafl@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+help@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+help@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+help@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


+----------------------------------------------------------+
  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                  
  mailto:mikes@kuentos.guam.net                            
  mailto:msetzerii@gmail.com
  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 users+help@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