The simplest way is to put the formula +(A1-B1)/A1 in cell C1, and then
Format cell C1 as a percentage with 2 decimal places.

Hope that helps,
Andy
--------------------------------------------
Andy Lee, Tutbury, Staffordshire, England
[log in to unmask]
--------------------------------------------

-----Original Message-----
From: Harold E. Schumacher, Jr. <[log in to unmask]>
To: [log in to unmask] <[log in to unmask]>
Date: 08 January 1999 15:58
Subject: [PCSOFT] @Function for 123R4


>Hello all,
>
>        I must be missing something painfully simple, but I'm having a hard
>time with getting the formula right for the following:
>
>@ Function formula for Lotus 1-2-3-R4
>
>Sheet has these (and other) columns:
>
>Total lines     ex. 521       (column A)
>Lines shorted   ex.  10       (column B)
>Fill Rate       ex.  98.08%   (column C)
>
>
>I need the formula to calculate the percentage for me.  Any
>suggestions?  I've looked at the book so much, I'm going cross-eyed!
>
>
>Thanks for your time.
>Harold E. Schumacher, Jr.
>--
>***********************
>*  Know Fear...       *
>*     Proverbs 9:10   *
>*         <><         *
>***********************
>Mailto:[log in to unmask]
>
>                         PCSOFT's List Owner's:
>                      Bob Wright<[log in to unmask]>
>                        Drew Dunn<[log in to unmask]>
>
>

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                        Drew Dunn<[log in to unmask]>