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: [email protected]
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
