XIRR Formula does not display.

Topics: Developer Forum
Jul 9, 2015 at 9:06 AM
Edited Jul 9, 2015 at 9:23 AM
Thanx in advance.


I Calculate XIRR but does not show in cell.
Please help me.

My Code.

$irr_cal = '=XIRR(D6:D9,A6:A9,0.1)';
$objPHPExcel->setActiveSheetIndex(1)->setCellValue('B1', $irr_cal);