Which two cells contain the formulas and are you sure they are locked?

Are they really being deleted or do they look empty because D14 does = N/A?


Gord Dibben MS Excel MVP


On Wed, 21 Jan 2009 12:01:02 -0800, JSnow
wrote:

I have two cells that, although locked on a protected sheet, can still be
deleted or altered. I can't figure out why. Each cell contains a formula
that calulates tax:
=IF($D$14="n/a","",$D$14*D16) where D14 is the subtotal and D16 is the tax.

All other cells in the sheet are protected properly. Can anyone help me
with this?