Problem Function 'IF'

Sep 29, 2009 at 3:28 AM
Edited Sep 29, 2009 at 3:36 AM

Hi koyama, please help me

$objPHPExcel->getActiveSheet()->setCellValue( "V1", "=IF(E1=2%,TRUE,FALSE)" );

=> Fatal error: Uncaught exception 'Exception' with message 'Syntax error: comma expected in function IF, arg #1' in ...


こやま は 小山 ですか


Sep 29, 2009 at 3:46 AM

Sorry, we have still not had time to fix problems in the formula parser for PHPExcel_Writer_Excel5

% (percent) is not supported, TRUE / FALSE is not supported. As a workaround you can perhaps use this:

$objPHPExcel->getActiveSheet()->setCellValue("V1", "=IF(E1=0.02,TRUE(),FALSE())");


はい、小山です :-)

Sep 30, 2009 at 2:14 AM

小山さん、どうも ありがとう ございます。^:)^