Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
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 cooling their heels in the Monastery: (5)
As of 2015-08-31 23:11 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (366 votes), past polls