http://www.perlmonks.org?node_id=999560


in reply to percentage problem

Use a formula like this one from the documentation: 
$worksheet->write('A12', '=A3 + 3*A4'          ); # write_formula()
# For your case,
# Use     my $format = $workbook->add_format(); # Create a percentage 
+format (Do some research here)
$worksheet->write('A6', '=(A4+100)*100/(A5+200)'    ,$format      ); #
+ write_formula()

[download]

             I hope life isn't a big joke, because I don't get it.
                   -SNL

In Section Seekers of Perl Wisdom