Logic & Error Fixes

Use IFERROR to show a clean fallback when a formula returns an error.

Fix #N/A errors in lookup formulas by checking missing matches, spaces, data types, and exact-match settings.

Fix #VALUE! errors caused by wrong data types, text in math formulas, dates stored as text, or invalid arguments.

Fix #REF! errors caused by deleted cells, broken references, moved ranges, and invalid lookup column numbers.

Fix #DIV/0! errors when a formula divides by zero, blank cells, or missing values.

Fix #NAME? errors caused by misspelled functions, missing quotes, unsupported formulas, or bad named ranges.

Fix #CALC! errors in Excel dynamic array formulas such as FILTER, MAP, and LAMBDA.

Fix circular reference warnings when a formula refers back to its own cell or dependent result.

Fix numbers stored as text so SUM, lookup, pivot tables, and comparisons work correctly.

Troubleshoot formulas that show errors, return the wrong result, or display as text.

Fix formulas that display as plain text instead of calculating in Excel or Google Sheets.

Fix Excel formulas that do not update because calculation mode is manual, cells are formatted as text, or references are stale.

Fix #SPILL! errors in dynamic array formulas by clearing blocked cells and checking output size.