If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I figure a 15% projected increase of current quotas?
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. |
#2
|
|||
|
|||
how do I figure a 15% projected increase of current quotas?
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. |
#3
|
|||
|
|||
how do I figure a 15% projected increase of current quotas?
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. |
#4
|
|||
|
|||
how do I figure a 15% projected increase of current quotas?
"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. |
Thread Tools | |
Display Modes | |
|
|