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+h...@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