Hello Sir,

I have a spreadsheet with a simple formula, for example, =SUM(1+((B2/C2)-1))*B1.

Now if I delete C2, then the formula became: =SUM(1+((B2/#REF!)-1))*B1

For some reason, the formula still produces a value as 0. Don't understand why because the automatic calculation is already on.

If this is tricky, is there a way to use a formula to detect if a formula contains specical characters such as #REF?

Thanks a lot in advance.