Problem Function 'IF'

Sep 29, 2009 at 4:28 AM
Edited Sep 29, 2009 at 4: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 ...

こやまさん、ありがとうございます。^^

こやま は 小山 ですか

 

Developer
Sep 29, 2009 at 4:46 AM

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

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=7895

% (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 3:14 AM

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