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

G

Guest

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.
 
S

SteveW

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
 
G

Guest

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)
 
G

Guest

Marian said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top