Use Defined Name to Reference Formula

[2Excel]

I have a lengthy formula I want to be able to change in one place. I've tried to call it from the cell as a defined name. However, it returns an error of #N/A when if the exact same formula were in the cell directly it calculates correctly. Ideas? Possible to do this through defined name?

UPDATE: Fixed itself. Not sure what's up.