In article <40DCB0EE-131A-4EF9-B38C-11A7850FC797@[EMAIL PROTECTED]
>,
Rae <Rae@[EMAIL PROTECTED]
> wrote:
> Cust# Sept.08 Sept.07 Act Diff Pct Diff bills bills
> 29806 $1,838.70 $1,219.45 619.25 51 16 10
> I need to be able to create a formula stating if the Pct Diff is over 5%
> what is the pct of Sept 08($1838.70) totals.
Start by parsing your example text better.
Assuming you posted two rows, the top one of which is the header,
then
=if(E2>0.05,C2/B2,"")
Where col E is PctDif, C2 is Sept 07, B2 is Sept 08
That is a row-by-row calculation.
If you want a sum of all rows which meet that criterion, look up SUMIF
--
Team EM to the rescue! http://www.team-em.com
|
