|
|
Need Help Fast! How to Calculate a sales percentage
I am trying to give the sales percentage between two cells and am not sure
how to do it... Any help would be greatly appreciated. I am under a
deadline!!
|
|
0
|
|
|
|
Reply
|
 Utf
|
12/5/2009 6:35:01 PM |
|
To get the percentage that A1 is of A2, simply divide A1 by A2 and format
the cell that contains the formula as percentage. The formula is =A1/A2
HTH Otto
"JacoPeanut" <JacoPeanut@discussions.microsoft.com> wrote in message
news:0995C18B-6AB5-4C01-A5D3-C8ECC389CB55@microsoft.com...
> I am trying to give the sales percentage between two cells and am not sure
> how to do it... Any help would be greatly appreciated. I am under a
> deadline!!
|
|
|
0
|
|
|
|
Reply
|
Otto
|
12/5/2009 6:55:02 PM
|
|
With sales in A2 and COGS in B2, put this in C2:
=B2/A2
Right-click, format cells, percentage, OK.
HTH,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"JacoPeanut" wrote:
> I am trying to give the sales percentage between two cells and am not sure
> how to do it... Any help would be greatly appreciated. I am under a
> deadline!!
|
|
|
0
|
|
|
|
Reply
|
Utf
|
12/5/2009 6:56:01 PM
|
|
You'll have to tell us what you mean by "the sales percentage", and you'll
have to tell us what is in your two cells.
If A2 contains the sales in one period and B2 contains the sales in the next
period, and you want to know the percentage increase from the one period to
the next, then it would be =B2/A2-1, formatted as percentage.
--
David Biddulph
"JacoPeanut" <JacoPeanut@discussions.microsoft.com> wrote in message
news:0995C18B-6AB5-4C01-A5D3-C8ECC389CB55@microsoft.com...
>I am trying to give the sales percentage between two cells and am not sure
> how to do it... Any help would be greatly appreciated. I am under a
> deadline!!
|
|
|
0
|
|
|
|
Reply
|
David
|
12/5/2009 6:58:54 PM
|
|
|
3 Replies
208 Views
(page loaded in 0.07 seconds)
Similiar Articles: Percentage between two numbers - microsoft.public.excel.misc ...... A1) =(B2-A2)/ABS(A2) I need a formula to calculate the percentage ... In other sheet i need to make a sales ... Can you help me with a solution? I need > > to ... how do i increase the value of numbers in a column by a percentage ...How do I calculate the percentage of email i receive over time ... ... Need help to know How to Multiply results in a report ... etc.) that uses price pages for our sales ... Auto Calculate Monthly Time Pace - microsoft.public.excel ...If you get a #NAME error, see the Help ... TODAY(),1)) format cell as percentage "HeatherJ" wrote: > I need to ... How to Calculate Sales Forecasting | eHow.com If the ... Calculating Percentage in Query. - microsoft.public.access.queries ...My issue is to calculate the percentage for each company in a ... Any help really appreciated. Thank you ... CntFemale In the pivot report, I need to show the percent ... SQL cumulative percent formula - microsoft.public.access ...I need to calculate sales order MTD totals and YTD ... SQL cumulative percent formula ... SQL cumulative percent formula - microsoft.public.access ... Kindly i need help ... calculate percent of a col in pivot report - microsoft.public ...Percentage when total sales is a credit - microsoft.public ... In a report, this may help: > > http ... A1) =(B2-A2)/ABS(A2) I need a formula to calculate the percentage of ... Excel Function for Tax Calculations - microsoft.public.excel ...Percentage function in a report - microsoft.public ... How to Calculate Annual Credit Sales | eHow.com... credit sales are ... Custom Vba Function - Tax Calculator - Need Help! Calculating percent of a field in two different records ...Hi, I have actual and projected customer sales ... Can someone help with this? Thanks ... You can calculate the percent ... ll need to keep accurate records ... Cumulative calculation - microsoft.public.access.queries ...Hope this helps you help me, Daniel Jeff Boyce ... I need to calculate sales order MTD totals and YTD ... SQL cumulative percent formula - microsoft.public.access ... Conditional formatting and percentages - microsoft.public.excel ...> > Please help me! > > Scott ... by conditional formatting ... Calculate percentage based on ... ... A1 (e.g. salesman�s name), and the percentage of actual sales ... Retail Sales Percentage Increase / Decrease CalculatorCalculate the difference between two sets of sales figures to find the increase or decrease percent with this ... Do you need to know how much retail sales ... Help; Write for ... How to Find a Percentage | eHow.comHow to Find a Percentage. There are time when ... Or maybe you need to know what percentage of your ... How to Calculate the Sales Charge Percentage; How to Calculate a Loan ... Calculate the Sale Price of an Item on Sale - WebMathIs something on sale, advertised at "so much" percent off? How much is it going to ... Quick! I need help with: How To Calculate Percentage? - Blurtit - Mathematics - Ask ...Mathematics Question: How To Calculate Percentage? ... Is just 7, you don't need the zeros ... How Do You Calculate The Percentage Change In Two Numbers (sales From One Year To ... Percentage CalculatorsFree math lessons and math homework help from basic math to algebra, geometry and ... 3-way Percent Calculators 7/9/2012 5:36:19 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
39 followers. 