Complicated Problem

[Guest]

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.

 

[Richard Buttrey]

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
__________________________

 

[Guest]

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]

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

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
Grappenhall, Cheshire, UK
__________________________