Skip to Content
0
Former Member
Feb 05, 2009 at 12:45 AM

Error formula

13 Views

Hi

I have a formula that lets me calculate the payback period of an investment, this works fine in excel but I get a "NaN" error when I preview in xcelsius. The formula is

=COUNTIF($G90:$AF90,"<0")1-INDEX($G90:$AF90,COUNTIF($G90:$AF90,"<0")1)/INDEX($G87:$AF87,COUNTIF($G90:$AF90,"<0")+1)

Can anyone suggest why thie doesnt work and if there is a fix or an alternate formula that calculates payback.?

Thanks