that's exactly what i need, thank you.

Louise

"Gary" wrote:

> If i understood right...
>
> A1 = 390
> A2 = 217
>
> to get the difference, enter the following formula.
>
> ==(A1-A2)/A1
>
> Format cell as percentage.
>
> this means that the sales this month are 46.36% less than last month.
>
> Is this what you need?
>
> "Louise" <Louise@discussions.microsoft.com> wrote in message
> news:004475F0-E180-40EE-B538-22E3C7878639@microsoft.com...
> > Hi all
> >
> > I'm sure this will be an easy calculation for most of you...........
> >
> > If I have two numbers, ie. 390 and 217, how can I calculate the difference
> > between the two figures as a percentage? (These two figures represent
> > sales
> > in two months and I need to know the difference in percentage terms).
> >
> > Thank you.
> > Louise
>
>
>