OpenOffice SEARCH function returning #value!

Thank you, matic, for your solution:

Sat Apr 07, 2012 5:29 pm

=IF(NOT(ISERROR(FIND(“John”;D2)));John;””)

It’s a bit [kludgy], but it works! :super:

Agreed, kludgy indeed, but the boss doesn’t care (grin).  NB: I replaced the commas (,) with semicolons (;).

Advertisements
This entry was posted in Career.

2 comments on “OpenOffice SEARCH function returning #value!

  1. larikaz says:

    =IF(ISERROR(FIND(“John”;D2)));””;John)
    Does this not give the same result with one less kludge?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s