Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Fast! How to Calculate a sales percentage
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" wrote in message ... 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!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Fast! How to Calculate a sales percentage
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!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help Fast! How to Calculate a sales percentage
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" wrote in message ... 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply various percentage with sales between a & b, b & c, etc. | Excel Worksheet Functions | |||
Sales comparison percentage question | Excel Discussion (Misc queries) | |||
How do I calculate year vs. year sales in a percentage? | Excel Discussion (Misc queries) | |||
formula to calculate sales tax from total sales | Excel Worksheet Functions | |||
percentage of sales | Excel Worksheet Functions |