ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I figure a 15% projected increase of current quotas? (https://www.excelbanter.com/new-users-excel/109171-how-do-i-figure-15%25-projected-increase-current-quotas.html)

Marian

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.

SteveW

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.


Nobody

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.


[email protected]

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.


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com