XNPV with Formula Builder

[mlc]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When using the Formula Builder to complete an XNPV function in Excel (12.1.5), Excel will crash when setting the "values" field. The "rate" and "dates" fields work correctly. This is more of a statement, as I do not see anywhere to submit bugs.

 

[CyberTaz]

Yeah, I'm seeing the same thing here :-\

The best way to submit the Bug is to use the Send button right there in the
window that pops up announcing the crash. It not only reports the problem
but also includes a copy of the crash report.

Additionally you can use Help> Send Feedback to submit a message on the
issue - Both go directly into the MacBU channels & will be reviewed & tested
although you most likely will not receive a direct reply.

I'll run up a flag on it as well. Thanks for catching it!

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

When using the Formula Builder to complete an XNPV function in Excel
(12.1.5), Excel will crash when setting the "values" field. The "rate" and
"dates" fields work correctly. This is more of a statement, as I do not see
anywhere to submit bugs.

Ouch. Fortunately, entering directly in the formula bar or cell works
fine.

Also, based on my limited testing, entering the Values and Dates
arguments, THEN entering the rate argument avoids the crash.

Please submit bugs via Help/Send Feedback...

I've also submitted it.

Thanks for the report!