2016 Archives by date, by thread · List index

# [libreoffice-users] Calc a formula conundrum

```Hello
A Calc conundrum
I’m wondering if there is a simpler way of doing this

Cell I5 contains a line of text from a bank statement the content will
include or not a key word,
key words are Lidl, SE Gas, Water etc etc
The formula below (in C5) looks at content in cell I5 if the cell contains
one of the key words then a corresponding name is produced in cell C5 ie.
Lidl = Lidl, Water = Water etc etc.

The formula does work, however it is long and is laborious to add new key
words and I’m hoping someone might know a better way of doing it.
New key words would be ‘HOLLAND & BARRETT’ and ‘PAYPAL’ and more as needed.
I’m wondering if its possible to have a list of key words ?

I’ve attached an example – which will make my explanation more clear ? I
hope

=IF(ISNUMBER(FIND("LIDL",I5)),"LIDL",IF(ISNUMBER(FIND("SE
GAS",I5)),"GAS",IF(ISNUMBER(FIND("WATER",I5)),"WATER
",IF(ISNUMBER(FIND("LEGAL & GENERAL",I5)),"LEGAL & GENERAL
",IF(ISNUMBER(FIND("SOUTHERN",I5)),"ELECTRIC",IF(ISNUMBER(FIND("TALKTALK",I5)),"TalkTalk",IF(ISNUMBER(FIND("MORRISON",I5)),"MORRISON",IF(ISNUMBER(FIND("ALDI",I5)),"ALDI",IF(ISNUMBER(FIND("HERON",I5)),"HERO
BANK_STATEMENT.ods
<http://nabble.documentfoundation.org/file/n4199203/BANK_STATEMENT.ods>
N","NO"))))))))

-----
IGraham

W764  LibreOffice 4.4.2.2
--
View this message in context:
http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203.html
Sent from the Users mailing list archive at Nabble.com.

--
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
```