We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Hans89's profile - activity

2020-10-30 22:22:35 +0200 marked best answer No error in nested function when forgot the function separator

Hi,

When I use the formulas below, I will get a strange result when I forgot the function separator and is don't know why there is no error is shown.

When I use this formula what in my opinion is wrong there no error shown, I miss the function separator before the second NOT function. The result TRUE or FALSE is given, based on the last part of the second NOT function.

=AND(NOT(IFERROR(IF(SEARCH(":",$F11)>=SEARCH("U",$F11),1,0),0))NOT(IFERROR(IF(SEARCH(":",$F11)>=SEARCH("F",$F11),1,0),0)))

When I remove both NOT functions the formula gives: Err:508 this is correct!

=AND(IFERROR(IF(SEARCH(":",$F12)>=SEARCH("U",$F12),1,0),0)IFERROR(IF(SEARCH(":",$F12)>=SEARCH("F",$F12),1,0),0))

When I put extra bracket add the NOT functions there is an error (Err:508) shown...

=AND((NOT(IFERROR(IF(SEARCH(":",$F11)>=SEARCH("U",$F11),1,0),0)))(NOT(IFERROR(IF(SEARCH(":",$F11)>=SEARCH("F",$F11),1,0),0))))

My question about it, which formula is wrong the first or the last one or how should I use it in this situation?

Thank you.

Libreoffice Version: 6.0.1.1 Build ID: 6.0.1-1 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: kde4; Locale: en-US (nl_NL.UTF-8); Calc: group threaded

2020-03-05 01:21:20 +0200 received badge  Famous Question (source)
2018-02-20 15:32:37 +0200 commented answer No error in nested function when forgot the function separator

Oke thank you!

2018-02-19 22:48:40 +0200 received badge  Notable Question (source)
2018-02-19 20:36:49 +0200 answered a question No error in nested function when forgot the function separator

Thank you for your answer Lupp! I tried your formula and I found that I had to change a setting about regular expressio

2018-02-17 08:54:57 +0200 received badge  Popular Question (source)
2018-02-16 22:11:05 +0200 edited question No error in nested function when forgot the function separator

No error in nested function when forgot the function separator Hi, When I use the formulas below, I will get a strange

2018-02-16 22:06:54 +0200 asked a question No error in nested function when forgot the function separator

No error in nested function when forgot the function separator Hi, When I use the formulas below, I will get a strange