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

 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