My statement is returning #N/A instead of the if false value. Works fine for the true value. Ive simplified it down to this; =IF(MATCH(B5,’Size Ref’!A4:A9,0),”oops”,”helpme”) But ultimately the equation will be; =IF(MATCH(B4,’Size Ref’!$A$4:$A$9,0),(((INDEX(‘Size Ref’!$B$4:$B$9, MATCH(B4,’Size Ref’!$A$4:$A$9, 0), 1))*D4) + ((INDEX(‘Size Ref’!$F$4:$F$9, MATCH(C4,’Size Ref’!$E$4:$E$9, 0), 1))*D4)), “—“) or whatever it is […]
Daily Archives: May 15, 2026
5 posts
Disclaimer: I’m not an electrician or programmer, and I did this with the battery connected (power cable unplugged). I don’t know if that was safe, so don’t copy this blindly, use your own judgment and gloves. But I didn’t feel any electricity and my WiFi signal returned to high. Another […]
My system : lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 24.04.4 LTS Release: 24.04 Codename: noble inxi -b System: Host: Laptop2 Kernel: 6.8.0-111-generic arch: x86_64 bits: 64 Desktop: KDE Plasma v: 5.27.12 Distro: Kubuntu 24.04.4 LTS (Noble Numbat) Machine: Type: Laptop System: ASUSTeK product: VivoBook_ASUSLaptop […]
I am MS Remote Desktop to watch instructional videos on YouTube. The video comes through perfectly fine. The audio does as well, but seems to be delayed by .5 of a second. Is there any way through Remote Desktop, the browser, or OS to sync up the audio while doing […]
One of the first bugs I noticed on Windows 11 after moving from 10 was the “Pin to Quick Access” function – every time I want to pin an item, it will not show on Quick Access until after I restart explorer. Is there a fix to this? A reddit […]