Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

percentage problem

by vikram007
on Oct 17, 2012 at 08:54 UTC ( #999494=perlquestion: print w/ replies, xml ) Need Help??
vikram007 has asked for the wisdom of the Perl Monks concerning the following question:

<percentage problem:i am using Spreadsheet::ParseExcel module and i am taking two value and i add these two value into tow different cells suppose 'A4'cell a add 100 and 'A5' cell i add 200 and cell 'A6' i am taking divide of A4/A5 so i need result in percentage how can i do that ? please he lp me ..>

Comment on percentage problem
Replies are listed 'Best First'.
Re: percentage problem
by moritz (Cardinal) on Oct 17, 2012 at 09:11 UTC
Re: percentage problem
by marto (Bishop) on Oct 17, 2012 at 09:22 UTC
Re: percentage problem
by NetWallah (Abbot) on Oct 17, 2012 at 15:21 UTC
    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()

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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://999494]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (9)
As of 2015-07-30 08:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls