EXCEL: SNUMBER inside IF statement with INDIRECT

If I use the excel formula: =ISNUMBER(MATCH(C2,INDIRECT({“D3″,”D6″,”D8”}),0)) And put a number in C2 and in D3 (or D6 or D8), the result is TRUE. However, once I wrap this formula inside an IF statement (inside the same cell: =IF(ISNUMBER(MATCH(C2,INDIRECT({“D3″,”D6″,”D8”}),0)),TRUE,FALSE) the same input number is always FALSE. Why would wrapping the first formula inside an IF…

Details

NetworkManager not listing wifi

A few days ago my computer(Arch Linux + Gnome) suddenly couldn’t connect to the network, NetworkManager couldn’t scan any wifi connection. systemctl status wpa_supplicant output ioctl[SIOCSIWENCODEEXT]: Operation not supported.I tried to downgrade NetworkManger, wpa_supplicant, kernel and so on, but nothing work. And then I tried to use another application — wifi-menu to connect wifi. But…

Details

Can’t sync time to network server on Ubuntu 19.10

Upgraded to 19.10 a three weeks ago, and since then, I can’t get the system to sync with a time server. What I’ve done: [email protected]:~$ cat /etc/timezone America/Los_Angeles [email protected]:~$ timedatectl Local time: Tue 2020-01-14 15:18:24 PST Universal time: Tue 2020-01-14 23:18:24 UTC RTC time: Tue 2020-01-14 23:18:27 Time zone: America/Los_Angeles (PST, -0800) System clock synchronized:…

Details