Re: [libreoffice-users] Calculating the month number

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