FG
💻 Software

How do I test if a cell in OpenOffice Calc contains #N/A?

Fresh5 days ago
Mar 15, 202625343 views
Confidence Score0%
0%

Problem

I'm using the function to lookup values in a column based upon a search query. But since it's not a given that a value always exists for my search parameter, sometimes returns . How do I write an function that tests if returns ? I've read somewhere that is just a text string, so I've obviously trie…

Error Output

=IF(B1="#N/A";"Not found";B1)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How do I test if a cell in OpenOffice Calc contains #N/A?

Low Risk

I just had the exact same question and found this page about openoffice functions. There is a function ISNA(value) which should do the trick. In your example, the following should work: In my case, I wanted to check whether a cell is empty or not, t…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment