Manage #N/A value for a cell in excel

Hello community,
i create a datable from an exported excel file, the problem is that i can’t detect if a value is equal to #N/A, i used isError but it doesn’t work, any idea please!


If possible, can you attach an excel in which you’re looking #N/A value?

Sorry for the delay
Here is it, fh_data_import.xlsx (8.9 KB)

For the Read Range properties you can click the “PreserveFormat”