LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default XIRR and EDATE functions return as #NA in 2007 in compatability mo

XIRR and EDATE functions are sometimes changed to #NA in 2007 when saved in
compatability mode. This does not happen everytime, but has happened to a
number of spreadsheets. These provide crucial information to the company and
would like to know how to fix this.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Compatability Jeff Excel Discussion (Misc queries) 1 May 29th 08 08:05 PM
When save as another file, EDATE and XIRR functions return #N/A nguyensea Excel Worksheet Functions 0 July 24th 07 05:06 PM
XIRR 0.00% Return with Small First Deposit Jan Excel Worksheet Functions 1 September 28th 06 03:00 AM
Excel 2007 Compatability Tintin Excel Discussion (Misc queries) 0 June 5th 06 05:19 AM
edate and yearfrac functions not tallying slymeat Excel Worksheet Functions 1 September 22nd 05 06:28 PM


All times are GMT +1. The time now is 10:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"