|
How would I use the $worksheet->repeat_formula option to save lines of code instead of coding it the way i have below??
$worksheet->write(1, 3, '=IF(AND(F2="",H2="",J2=""),"",MAX(F2,H2,J2))', $format);
$worksheet->write(2, 3, '=IF(AND(F3="",H3="",J3=""),"",MAX(F3,H3,J3))', $format);
$worksheet->write(3, 3, '=IF(AND(F4="",H4="",J4=""),"",MAX(F4,H4,J4))', $format);
$worksheet->write(4, 3, '=IF(AND(F5="",H5="",J5=""),"",MAX(F5,H5,J5))', $format);
$worksheet->write(5, 3, '=IF(AND(F6="",H6="",J6=""),"",MAX(F6,H6,J6))', $format);
$worksheet->write(6, 3, '=IF(AND(F7="",H7="",J7=""),"",MAX(F7,H7,J7))', $format);
$worksheet->write(7, 3, '=IF(AND(F8="",H8="",J8=""),"",MAX(F8,H8,J8))', $format);
$worksheet->write(8, 3, '=IF(AND(F9="",H9="",J9=""),"",MAX(F9,H9,J9))', $format);
$worksheet->write(9, 3, '=IF(AND(F10="",H10="",J10=""),"",MAX(F10,H10,J10))', $format);
thanks
|