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