#NAME when I open up my spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I open up my spreadsheet I get a #NAME error in one of my cells, but if
I go to the formula and press enter it gives the answer!

Any ideas why it does this? - I want to hide this cell, so don't like the
manual workaround!

Thx
 
The formula is:

=(4-SPAq)/4*new_fsa_annty(SPAy,YEAR(DOB),SPAy+3,YEAR(DOB)-3,"F",INTEREST_RPI,0%,0,50%,12,"adv",4%,"y")+SPAq/4*new_fsa_annty(SPAy+1,YEAR(DOB),SPAy+1+3,YEAR(DOB)-3,"F",INTEREST_RPI,0%,0,50%,12,"adv",4%,"y")

where new_fsa_annty is a user-defined function
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking spreadsheet 1
Excel Excel spreadsheets opening at top instead of bottom. 4
INDIRECT doesn't retain data from external worksheets 2
Excel Spreadsheets keep moving 0
Count cells in range w/specific background color? 3
Spreadsheet reference in formula? 2
Getting #name? error in cells after sending spreadsheet via email 6
drag formula down from columns that go acros 3

Back
Top