Increase / Decrease Numbers Evenly For Spreadsheet

Aug 27, 2012

How to increase & decrease numbers evenly for a spreadsheet.

I have a number in cell F16 that can be changed and for this example say it has a value of 900.
I have a number in cell F17 that is always more than cell F16, for this example lets say it is 1000.

What I'm trying to do is create 10 numbers evenly increasing away from 900 (F16) in value, & 10 numbers evenly decreasing in value away from 900 (Cell F16) but here's the catch.

What makes this tricky is that the numbers that are increasing in value away from 900 (F16) can't be bigger than the value of F17 , IE in this example the number 1000

So the formulas must evenly distribute 10 numbers BETWEEN 900 & 1000. This must have the same even distribution for the increasing numbers & decreasing numbers.

I'll attach a sheet also. So, if you say 900 is a starting point & 1000 is the ending point, what formulas would you need in each cell to evenly increase to 1000?

Also,, going the other way, decreasing, away from 900 at the same rate as the increase?

Really stuck n this 1.
Spreadsheet here: [URL] ......
Screenshot here: [URL] ......

I'll attach a spreadsheet .xls

View 5 Replies


ADVERTISEMENT

Find Percentage Increase / Decrease Between 2 Numbers

Mar 4, 2014

I have totals in d18 and e18 and need to find the percentage increase or decrease between the 2. E18 is last year's value and D18 is this year's value. Which formula will give me what I am looking for:

(D18-E18)/D18 or (D18-E18)/E18

View 2 Replies View Related

Increase / Decrease Of Value Set?

Dec 11, 2013

I'm dealing with the following problem. Say I have a set af values:

A B
1 567
2 546
3 567
4 554
5 572
6 543

I can easily determine the average of the values in column B (=AVERAGE(B1:B6)) But I also want to know if the average is increasing or decreasing without making a chart and trendline. Concrete: I want the cell with average (say B7) to turn green when the trendline has a positive growth and red when negative.

View 2 Replies View Related

% Of Increase - Decrease - Formula

Sep 18, 2006

Simplified:
I have a this years total in A1, last years total in B1, difference +/- in C1

$1000.00___$800.00___+$200.00___+%
$800.00___$1000.00___<$200.00>___<%>

I am trying to get a % of Increase/Decrease (Between A1 and B1) in D1.
Not as a dollar amount but as a %.

I have tried Percentile and PercentRank and some other stuff. No joy.

View 12 Replies View Related

Increase/decrease Values Individually?

Oct 13, 2008

I have a single simple question, so let's get straight to the point: I have an A column with these values:

I:::I::::::A::::::I::::::B:::::....
I==================== ....
I 1 I____40____I_________ ....
I 2 I____50____I_________.....
I 3 I____30____I_________.....

And I need each of these values increased/decreased by a constant number.

So far, I only found formulas where all cells are, say, added into a single result, as you can see here:.....

View 2 Replies View Related

Getting A Value To Increase Or Decrease Number Or Rows...

Aug 6, 2009

I need to be able to select a certain number (from, say, 1-20) from a drop down menu, which will decide a number of rows (filled with data) on the next sheet. As I prefer not to give anyone the sheet I'm actually working on I made a quick look-a-like which might explain this better.

A and B are different scenarios, with different values in the fake drop-down menu I made. Just to pass on the understanding of what I want the values to do. If putting a drop-down menu there is troublesome, then I can live without them. But entering a certain value in the field and getting that number of rows for a certain product is what I need. I tried searching for a function/macro to use for this, but I dont know what exactly to look for. Name, etc

View 4 Replies View Related

Percentage Increase Or Decrease From Cell

May 2, 2012

I need a formula that can work out a percentage increase or decrease from cell J2 to L2.

J2 is the current data with L2 being the previous data - so the formula would compare J2 with L2 and tell me if there is an increase or decrease shown as a percentage.

The figures fluctuate from month to month so they could be either an increase or decrease. There are over 300 entries so I can't go through each one adjusting the formula accordingly - this is why I need the formula to do the working out if it is up or down.

View 7 Replies View Related

How To Add + Or - Button To Increase / Decrease Value In Cell

Sep 21, 2013

I have a simple spreadsheet. A value is inserted in cell B4.

I want to increase that value or decrease it by adding a button in the next cells, C4 or D4, to increase and decrease that value instead of manually typing in the new value.

View 7 Replies View Related

How To Count Decrease To Increase Match

Nov 18, 2009

Below i have example table in which Cells B2:G4 have draw numbers. In Cells I2:X4 I have numbers in 3 groups, Group start with small number and finish with highest number.

For example in row 2 first groups is 5 to 36, second group is 10 to 30 and third group is 4 to 41 and continue same for rest rows ....

View 9 Replies View Related

Format Number To Increase/decrease

Jul 31, 2006

How can i format my excel spreadsheet cell so that a number

10,000,000

displays as

10

View 4 Replies View Related

Increase/Decrease Times By X Hours

Aug 2, 2008

in speeding up the below code as it does not seem to matter whether I use For, If loop etc - it runs too slowly. Basically we have one sheet which is input in a different timezone that needs converting to GMT... since daylight saving I wrote some code to cover the +/- 1 hour difference (this seems to work quite well) yet when it comes to converting the actual cells it runs incredibly slowly. I appreciate any help but its only the code after "Sheets("data").Unprotect" that i think needs changing. The time stamp is in column 7 - I hope this makes enough sense - which then gets converted by either 4.5 or 5.5 hours dependent on british summer time.

Sub TimeConvert()

With Application
.Calculation = xlCalculationAutomatic
. ScreenUpdating = False
.DisplayAlerts = False
.EnableEvents = False
End With

Dim FirstDate As Date
Dim Position, DayIndex, lgrow, lstrow As Long, TargetMonth As Long, Stweekday, Enweekday, Tdate As Date, TargetYear As Long, cell As Range
Dim bst As Boolean

TargetYear = Year(Now)
TargetMonth = 3
Position = "L"
DayIndex = 1

View 3 Replies View Related

Macro To Increase And Decrease Cell Number

Apr 28, 2012

I have a macro that increase a cell number and one that decreases a cell number, heres my code:

Code:
Sub Macro1()
Dim t
t = Split(Worksheets("Sheet1").Range("d5").Text, "/")
t(0) = Format(t(0) + 1, "0")
Worksheets("Sheet1").Range("d5") = Join(t, "/")

[Code] .......

So they do exactly what i want them to do but i want to put a limitation on them, so say the number in the cell is 0 then i dont want it to be able to subtract from it anymore, and say the number is 20 i dont want it to be able to add any more, i tried to put if statments into the code but no luck.

View 3 Replies View Related

Change Cell Color After Every Decrease Up To Increase

Nov 15, 2009

I have a 49 numbers in cell A1:AW1 they are not in acceding order. I want to separate all groups’ start from lowest number to highest giving them deferent color. As shown in example table below in cell (A2 start with nº 6 and increase up to nº 47 till cell F2 =yellow color) then Cell (G3 decrease nº 3 and increase up to nº 49 till cell L49=Green Color) and continue same process for rest ....

View 9 Replies View Related

Command Button Size Increase / Decrease

Jan 22, 2008

I'm building a keypad out of commandbutton controls, and there's this strange resizing behavior with the commandbuttons. I've attached an example, as it's much easier to see than describe.... but essentially, clicking a button seems to enlargen it slightly, and then two clicks later, it 'dezooms' back to original size (even with shadows turned off). while this is not hugely noticeable individually, it feels really strange when there's a whole keypad of commandbuttons.

View 8 Replies View Related

Keyboard Shortcut To Increase Or Decrease The Number Of Decimals

Apr 21, 2009

Is there any keyboard shortcut to increase or decrease the number of decimals shown directly (I mean without having to use ctrl + 1... etc )

View 7 Replies View Related

Spin Button To Increase Or Decrease By 1 Each Time It Is Clicked Up Or Down

May 18, 2009

I am having difficulty finding information on coding my spin button on a user form. I searched and haven't found any information. I need to do is code a spin button to increase or decrease by 1 each time it is clicked up or down. I would like it to populate to a text box on my form if that is possible.

View 3 Replies View Related

Formula To Change Cell Colour :: Due To Sum Increase Or Decrease

Sep 28, 2009

how to change the cell colour due to a sum increase or decrease? For example: if the amount is greater than 200, change cell colour to green. If under 200 change cell colour to yellow.

View 2 Replies View Related

Dividing Numbers Evenly

Apr 6, 2009

I have a total at the bottom of my spreadsheet and I want to distribute that total equaly to the missing columns for each month and each product highlighted in green in the spreadsheet. What formula do I need to use to be able to do that?

At the end I want the numbers in each month to total the total at the bottom.

View 10 Replies View Related

Increasing/decreasing; Rate Of Decrease - Spreadsheet

Aug 24, 2006

I’m trying to make this:

Amount of money: 1000 (changeable)
Beginning # of units: 0,1 (changeable)
Delta: 200 (changeable)
Rate of decrease: 50% (changeable)

0,1 unit should be added for every 200$ increase (1000+200=1200; 1200+200=1400; 1400+500=1900; 1900+256=2156 etc)
0,1 unit should be taken away after decreasing by100$ (because the rate of decrease = 50% (changeable))

After increasing of 1000 + 200, quantity of units should also increase for 0,1, so it should be 0,2 (1200), 0,3(1400), 0,4(1600)….. Amount of money can increase not only by 200, but for any sum. If that sum is (for example) 500, we should increase by 0,2 etc.

But when this some decreasing we are using rate of decrease (for example 50%, (changeable):
0,4 units – 1600
0,3 units – 1500
0,2 units – 1400
0,1 unit – 1300

View 2 Replies View Related

Conditional Formatting Formula For Decrease In Numbers

Oct 16, 2013

I have a table that has labels of departments. Then each of those departments will be tracked per week on a number. I am looking for a formula for conditional formatting that if cell C5 is less than B5 that cell C5 (with the smaller number) fills green. Then depending on the next weeks number it will have no fill or a green fill if the number has decreased in cell D5.

Is there anyway that I can do an array of cells or do I have to do it individually per column?

View 2 Replies View Related

Create A Spreadsheet That Will Automatically Increase The Work Order Number By 1?

Jun 20, 2014

I am trying to create a spreadsheet that will automatically increase the work order number by 1. The cell will always be in the same place. The idea is that when the file is opened it populates the number. After being closed and reopened the number will be 1 higher than the previous.

The page will reused by various people to create and print work requests for my mechanics, I want it to assign the W/O automatically.

View 11 Replies View Related

Use VBA To Increase Numbers On Separate Worksheets Without Them Being The Same?

Feb 6, 2014

I have two worksheets and each one has it's own number. Sheet1 has "100" and Sheet2 has "101" and they're located in "A4" on each. Each sheet will have a control button that will be pressed when a sheet is complete. The control button will clear a range of cells "B5:C20" and increase the sheet number in "A4". So if you press the control button on Sheet1 the range will be cleared and the number will change to "102" since Sheet2 is already using "101".

View 2 Replies View Related

Automatically Increase Numbers At Interval By Percentage

Apr 21, 2008

how to make a number automatically increase by a percentage at a certain interval.

For example, 1-12 need to be 3% of 100, so, 3. Then, from 13-24 need to be 3.5% of 100, and so on. Does anyone know how to do this?

View 6 Replies View Related

IF Function Formula Logic: For Every Increase Of Of Mhz, Give 25.00 Per 100 Increase

Nov 2, 2006

I have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.

View 2 Replies View Related

Countif Evenly Divisible By 5

Sep 22, 2009

I have a column of numbers in cell A1 through A10.

In cell A11 I would like to count how many times the numbers listed from A1 through A10 are evenly divisible by 5.

How would I do this?

View 10 Replies View Related

Date Fields Increase Date By Numbers Of Years Based On Lookup Table?

Aug 11, 2013

In column A, I have dates; In column b i have security levels. I have made a table called "Security" it contains to columns, a list of security levels and no of years when each security level is required to be reviewed. the table is setup -

d1 e1
Restricted 5
etc

Example of data
ie.
a1 b1 c1
Restricted 1/06/2012 1/06/2017

What I am looking for is a formula to look up a1 "restricted". then lookup the security table and find "restricted" its value is 5 (years) then add the 5 years to date in b1, but place it in c1.

View 1 Replies View Related

Reduce GP Percentage Evenly For Two Departments

Aug 14, 2013

When we sell things here at a 'sale' price there is always an argument as to who's department needs to give the discount off.

Each job we do has a labour time and an hourly labour rate.

Each part has a profit in it.

So if something is normally £100 but we are going so sell it for £80 we need tio split the £20 reduction evenly to both departments based on the GP each department has in the sale.

See attached : GP Reduction per department.xlsx‎

View 4 Replies View Related

Distribute Duration Evenly Amongst Tasks?

Sep 10, 2013

I'm working on a project that will will have varying tasks & estimating the total duration to complete these tasks.

For example:

If estimating that the min-project will take 90 days & I have 17 tasks, how can I distribute the 90 days evenly amongst the 17 tasks?

View 5 Replies View Related

Formula To See If Cell Divides Evenly Into 5

May 22, 2014

I need a formula to do two things I need it to look at Cell C2 and if it does not contain a number then I want the letter A put in the cell, if it contains a number then if that number is divisible by five giving a whole number i.e like 10,15 20 would, then input 1, but if not 2.

View 1 Replies View Related

How To Spread Existing Data Evenly Throughout The Same Row

Sep 28, 2009

I don't know how else to ask this so I will just tell you what I'm trying to do.

-I have a list of name on one column say "A"
and this list of names goes through "A1" through "A145"

-I am taking those names and pasting them via "right click" "paste special"
"Values" onto another spreadsheet.

-BUT I have to take each name one by one and paste them evenly
in every 8th row for example ( "A1" A8" "A16" "A24" ...)

-Is there a way to take the existing data on that row and just spread it evenly throughout the same row? So I don't have to take names one by one by one...

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved