Hi all.
I've recently taken the step from google sheets to Excel. I've tried to download my google sheet into a Excel file and been fairly successful transfering it over - except one key formula that I'm using. The formula contains curly brackets and I believe that's the issue. My question is: Could anyone here help me get the following formula to work in Excel?
The formula:
=if(iserror(irr({(L$13*-1),M$18,N$18,(O$13+O$18)},0.1)),"",irr({(L$13*-1),M$18,N$18,(O$13+O$18)},0.1))
Thanks for your time.
Bookmarks