Advertisement

10.01.2007 at 04:45PM PDT, ID: 22865275
[x]
Attachment Details

calculate percentage

Asked by gp4pc in Microsoft Excel Spreadsheet Software, Microsoft Office Suite, Office & Productivity Software

Tags: excel, calculate, percentage

I have an excel document where column F shows the delivered weight and column G shows the used weight. I can calculate the percentage used by using the following formula
=SUM(G4/F4)*100
So if the delivered weight was 33 and the used  weight was 11 then this calculates to 33.33 percent.
But what I want to actually show is the percentage not used, the 66.66 percent in this case but i cannot work out the formula required.
Can anyone help?Start Free Trial
[+][-]10.01.2007 at 04:47PM PDT, ID: 19995237

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Microsoft Excel Spreadsheet Software, Microsoft Office Suite, Office & Productivity Software
Tags: excel, calculate, percentage
Sign Up Now!
Solution Provided By: matthewspatrick
Participating Experts: 2
Solution Grade: A
 
 
[+][-]10.01.2007 at 04:56PM PDT, ID: 19995293

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.01.2007 at 04:59PM PDT, ID: 19995306

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.01.2007 at 05:01PM PDT, ID: 19995318

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.01.2007 at 05:01PM PDT, ID: 19995322

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628