Variables in Spreadsheet:: WriteExcel

[rab54]

Hi gurus -

OK This works -

sample - $sheet1->write(8, 0, '=IF(A5>3,"Yes", "No")');

What I need is this -

$sheet1->write("$i", 3, '=(100/C$i) )*B$i/100', $format1);

$i is the row count - I am strugging with the '100/C$i' section -

I need to get the value of the 2nd/3rd $i's - I have tried '," and brackets around it but still get $i NOT the actual value -

If any-one can help it would most excellent ....

cheers

Rab

 

[Nebbish]

Try using double quotes:

$sheet1->write("$i", 3, "=(100/C$i) )*B$i/100", $format1);

-Nick