Thread: formula from Excel97 doesn't work in Excel2003,any ideas why?
View Single Post
  #1   Report Post  
nic
 
Posts: n/a
Default formula from Excel97 doesn't work in Excel2003,any ideas why?
The formula I'm using is
=IF(C3="","",EDATE(C3,(D3*6)))
and instead of producing the required date its giving me a #name? error

this worked absolutely fine in Excel97 but not in Excel2003 and I can't work
out why

Has anyone got any ideas?
Reply With QuoteReply With Quote