MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

Need Help Fast! How to Calculate a sales percentage

• Follow

```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
```
 0

```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

```
 0

```With sales in A2 and COGS in B2, put this in C2:
=B2/A2

Right-click, format cells, percentage, OK.

HTH,
Ryan--

--
Ryan---

"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
```
 0

```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

```
 0

3 Replies
208 Views

Similiar Articles:

7/9/2012 5:36:19 PM