Re: [libreoffice-users] Calculating the month number

Duh! I was trying to type the formula manually and forgot the cell
reference...

Thanks for the gentle use of the cluestick... :)

On 2011-05-25 10:33 AM, Manoharan Durga wrote:
> 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