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.

On Wed, 20 Sep 2006 15:05:03 -0700, saslou37
<(E-Mail Removed)> 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
__________________________

Hi Richard

Here's the information you requested. It asks for the conditions to be:
Region - East, Revenue - less than 20000, if it is both those then I have to
increase by 8%, anything else then there's to be no change.

Does that make sense? Sorry but I am so confused with this question.

"Richard Buttrey" wrote:

> On Wed, 20 Sep 2006 15:05:03 -0700, saslou37
> <(E-Mail Removed)> 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
> __________________________
>

Hi,

With your region (say "East") in A1 and your Revenue amount in B1,
then use the formula

=IF(AND(A1="East",B1<20000),B1*1.08,B1)

Rgds


On Thu, 21 Sep 2006 14:36:01 -0700, saslou37
<(E-Mail Removed)> wrote:

>Hi Richard
>
>Here's the information you requested. It asks for the conditions to be:
>Region - East, Revenue - less than 20000, if it is both those then I have to
>increase by 8%, anything else then there's to be no change.
>
>Does that make sense? Sorry but I am so confused with this question.
>
>"Richard Buttrey" wrote:
>
>> On Wed, 20 Sep 2006 15:05:03 -0700, saslou37
>> <(E-Mail Removed)> 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
>> __________________________
>>

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________