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.

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



On Fri, 08 Sep 2006 20:21:02 +0100, Marian
wrote:

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.

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

"Marian" wrote:

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.

"Marian" wrote:
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.

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