$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()