ExcelBanter - #NUM! error ...

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #NUM! error ... (https://www.excelbanter.com/excel-discussion-misc-queries/89769-num-error.html)

#NUM! error ...

I am trying to calculate growth rate using ...
=RATE(7,,-47.4,4552.4)

It works till fv is about 3000, but for the above value
I get #NUM! error. Any help is appreciated.

Michael M

#NUM! error ...

Take the second comma out.

" wrote:

I am trying to calculate growth rate using ...
=RATE(7,,-47.4,4552.4)

It works till fv is about 3000, but for the above value
I get #NUM! error. Any help is appreciated.

All times are GMT +1. The time now is 04:35 PM.