how do i calculate in excel % Available

How do i calculate in excel % available ex if i have 25 items and 3 are not
ready what % are ready?

If A1 = Number of items, B1 = Not ready, in C1 type =(A1-B1)/A1*100

"conley" wrote:

> How do i calculate in excel % available ex if i have 25 items and 3 are not
> ready what % are ready?

Don't multiply by 100, just format as percentage.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SVC" <SVC@discussions.microsoft.com> wrote in message
news:5DF16ABB-A44C-466D-8F57-44B569853863@microsoft.com...
> If A1 = Number of items, B1 = Not ready, in C1 type =(A1-B1)/A1*100
>
> "conley" wrote:
>
> > How do i calculate in excel % available ex if i have 25 items and 3 are
not
> > ready what % are ready?