Hi Tanstaafl, -------- Original Message -------- Subject: Re: [libreoffice-users] Calculating the month number From: Tanstaafl <[email protected]> To: [email protected] 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 [email protected] 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
