View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How do I use integration to work out the area under a curve?

All is revealed at:
http://people.stfx.ca/bliengme/Excel...UnderCurve.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Penfold1981" wrote in message
...
I'm trying to use Excel to work out some targets and I know I want a 4%
reduction over the year- i.e. I had 100 last year and want 96 this year,
so
how do I work out how many I need to record in each financial quarter to
make
that happen? It wouldn't be one per quarter because that would give me a
'flat-line' target and not a decreasing trajectory. Apparently there's a
formula, possibly something to do with integration and working out the
area
under a curve? Can anyone help??!