The Excel formula I use whenever #N/A takes over a sheet
https://www.makeuseof.com/the-ifna-function-in-excel/
IFNA function – Microsoft Support
https://support.microsoft.com/en-us/office/ifna-function-6626c961-a569-42fc-a49d-79b4951fd461
ALS.NB, functie – Microsoft Ondersteuning
https://support.microsoft.com/nl-nl/office/als-nb-functie-6626c961-a569-42fc-a49d-79b4951fd461