[libreoffice-users] Text in an IF function

Hi All

I'm using a lot of IF functions in my Spreadsheets to limit DIV and NAME 
errors with rows that don't have values in them yet.

I came across a situation today where I need to test text - ie I need to 
test for a month's name.

I tried =IF(Cell Ref="AUG",do calculation."")
But this gives NAME error.
Is it possible to test text in this way? Can't find anything with a 
Google on this.

PClinuxOS KDE 32-bit (latest); LO 4.1.3.2

Thanks
IanW
Pretoria RSA



--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted