On Wed, 20 Sep 2006 15:05:03 -0700, saslou37
wrote:

I have my advanced Excel ECDL assessment in the next few days and I can't
figure out how to do something. I have to add a function to calculate the
projected sales increase using specific conditions, does anyone know how to
do this? This probably isn't a hugely complicated problem but I am having
real problems with it.

In order to help we'll need to know what specific conditions you have
in mind.

As an example I guess you mean something like for every 1 degree
change in the average temperature for the projected period, I'll sell
15% more ice creams.

So with actual sales of ice creams in A1, and temperature increase in
B1 projected sales would be
=A1*1+(B1*.15)

But you will need to tell us.

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________