Re: [libreoffice-users] Calculating the month number

Hi Tanstaafl,

-------- Original Message --------
Subject: Re: [libreoffice-users] Calculating the month number
From: Tanstaafl <tanstaafl@libertytrek.org>
To: users@libreoffice.org
Date: 25/05/11 16:20
> Sorry, this is obviously in CALC...
>
> [...]
> > 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?
Try:

Try:

=IF(MONTH(NOW())>=5,1000000,0)

Lorenzo.

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