how do I figure a 15% projected increase of current quotas?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marian - 08 Sep 2006 20:21 GMT

I have entered a formula which figures a 10% projected increase in current
quotas. Now I am supposed to change it to a 15% projected increase. I
thought if I just changed the number from 1.1 to 1.15 I could get the new
numbers, but it didn't work.

Reply to this Message

SteveW - 08 Sep 2006 22:48 GMT

You may have to provide a little more info
perhaps some of your data and results
with the actual formula

On the face of it changing 1.1 to 1.15 looks correct
but we'll wait and see

Steve

> I have entered a formula which figures a 10% projected increase in
> current
> quotas. Now I am supposed to change it to a 15% projected increase. I
> thought if I just changed the number from 1.1 to 1.15 I could get the new
> numbers, but it didn't work.

Reply to this Message

Nobody - 09 Sep 2006 03:56 GMT

Let say your data in
A1 = 100
in B1 =A1*1.1 (the result 110) if you change from 1.1 to 1.15 (the result 115)

---------------
mama no teeth

> I have entered a formula which figures a 10% projected increase in current
> quotas. Now I am supposed to change it to a 15% projected increase. I
> thought if I just changed the number from 1.1 to 1.15 I could get the new
> numbers, but it didn't work.

Reply to this Message

joeu2004@hotmail.com - 09 Sep 2006 05:57 GMT

Take a look at Tools > Options > Calculation. Do you have Manual set
instead of Automatic? If so, press F9 to perform the modified computation.

Reply to this Message

Rate this thread: