Excel returning zeros (it shouldn't be)

Hi all,

Working on a model that was built by someone else and I am trying to make some changes.

When I first went to change a row of cells I couldn't even add in parenthesis without excel returning 0. Odd. I know my syntax is correct. So I assumed there was some strange number formatting occurring so I changed it to basic accounting style. But after dragging my new formula only about half the cells in my row are returning the correct values, while half are returning 0.

I'll list what I consider to be possible wrinkles:

-The formula is attempting to convert to a negative number...formula reads =-BS!L146*Interest_Rate/12

-I am now calling on a named cell opposed to a hardcoded number (although problem persists with a hardcoded number)


A final note is that the cells returning the correct numbers fail and return 0 if I add in parenthesis that shouldn't be changing the formula at all.

Thanks! I am stumped.

UPDATE: The cells that were working stop working if I simply click in the formula bar and then click out without changing anything. After that they return 0 again.