Re: [libreoffice-users] Calculating the month number

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 <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