Formula To Increase A Number By 10%?Feb 18, 2007
formula to put in microsoft excel 2003 to increase a number by 10%, so for example, 20 by 10%.
formula to put in microsoft excel 2003 to increase a number by 10%, so for example, 20 by 10%.
writing a formula for the situation below,
In column "A1" i have the formula =C8. I now need to copy this formula across to column "B1" to get =C9 and also copy it across to column "C1" to read =C10.
So the row number should be increasing by 1 and the column remanin constant.
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
what i need is a macro to run when I print a form. I am making a job card with a unique number on it ie: 100. when I print the form, I then need the 100 to change to 101 and so on. I cant work this one out.
EDIT - Ive attached my work in progress. It is for a computer repair shop. I have a few macros in there as I need to email a copy of the workbook too.
when you open the workbook, you will see the job number in red. I just need a macro tht will increase that number +1 every time it runs. I also need the email macro to rename the workbook to the customer name input in cell B4 - but I think im best to post this request in a new thread?
I have data to find standard deviation from a1:a5
So use a formulae to do the same.
I want to increase range automatically when i put a number in a6 and so on.
in cell A1 I have a ref no. eg aa/01/bb
in cell A2 I have a ref no. eg aa/02/bb
only the middle number increases in the reference each time eg: /01/
is there a formula that can achieve this or am i doomed to manual input, I have made a few attempts but cannot work it out.
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
I created an receipt template in excel. How can I have it increase the receipt invoice number by 1 every time I open this template? For example the first receipt is 100, I want the second receipt to be 101, and so on.View 4 Replies View Related
How can i format my excel spreadsheet cell so that a number
I am trying to write a program that needs to select a different cell everytime it is ran. For example, this month when it runs I need it to select cell BL137. Next time it is ran it will need to select cell BL138. Month after BL139. The cell it selects will always be in the same column (column BL) and the cell number always increases by the same amount (1).View 6 Replies View Related
I have set the check boxes for each line. I would like to have the today date to appear after clicking the check box on the next right cell. Do I have to use IF for this one?
ALSO I want the number to count up after click the check box. For example:
Bob (assigned)- 5
Every number of completed line increases every time each box is clicked. How can I do that?
I have a macro that increase a cell number and one that decreases a cell number, heres my code:
t = Split(Worksheets("Sheet1").Range("d5").Text, "/")
t(0) = Format(t(0) + 1, "0")
Worksheets("Sheet1").Range("d5") = Join(t, "/")
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.
I have many data in a worksheet named "Table" with "Item" in column A and "Reference" in column B. For each change of item, I need to assign a reference number with a prefix. Below is a sample of the data.
Column A Column B
The starting reference number is not fixed. It could start from 8 or 10.
Thought it would be possible to automate this process using vba.
I have multiple worksheets (too many, actually!) and each worksheet is a record. I need to enter a Record Number into B5 of each sheet. The Record Number doesn't start at 1. I'd like to enter a number into the first sheet and the rest of the sheets to increase by 1. However, I only need to do this to some sheets.View 9 Replies View Related
Can you increase the number of fields shown in the list so that you don't have to scroll through the entire list?View 2 Replies View Related
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
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.
I need an OFFSET function to start off by moving down 1 row from the starting point and then on the next run through the loop, to move down 2 rows, then 3 rows, etc.
Workbooks(Thisname).Worksheets("Run Set Up").Range("Duration").Offset(1, 0).Value = Workbooks(Filename2).Worksheets("Front Page").Range("T20").Value
This is what I'm working with. At the moment, I have the value for the number of rows to move set to 1 because I can't figure out how I'd accomplsih what I need.
Our business has a spreadsheet set up for invoicing. A Macro has been created to increase the invoice number, save to the desktop as a PDF with a file name taken from the cells
This is working on my colleagues mac but when we've loaded onto my computer it errors, when I debug I am getting the following error:
' Macro3 Macro
[g10] = [g10] + 1
I have a this years total in A1, last years total in B1, difference +/- in C1
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.
the example is as per above
formulas for D and E column
Column D : pro rate base on when hired
Annual Leave is calculated base on Jan 1 of every year.
* if analyst hired in the middle of the year, their leaves are pro rated base on Jan 1
Joined : 9/1/2008 : today is : 10/25/2013 :
Currently leave entitlement is : 12 days [Jan 1 to Sept 1] + 2.66 days [Sept 1 to Oct 25] = 14.66 days
Leave until 31st Dec 2013 : 12 days [Jan 1 to Sept 1] + 5.96 days [ Sept 1 to Dec 31] = 17.96 days
I have to reference to another sheet a fixed increase of moving 6 rows across. What would be the formula for it?
First formula would be =Sheet1!A1
What would be the formula for the subsequent cells. (eg. =Sheet1!A1+6) obviously doesn't work.
I would like to create a financial modeling spreadsheet. Basically my problem is this; I want to have a month by month row for 5 years. For the value of each one I would like it to increase by 950 per month automatically.View 4 Replies View Related
I've built a spreadsheet that accurately displays my company's price list. However, from time to time, there are increases and/decreases, by percentages. I would like to know how I can build a formula that would allow me to quickly update the pricesheets by the appropriate percentage, without having to manually do so, one cell at a time.View 2 Replies View Related
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
Looking for a formula to show percentage increase of a figure.
Cell A1 is £45,000
Cell A2 is £51,000
Cell A3 ANSWER result shown as a percentage increase.
I have a text box that is set to "=B1". B1 is a cell from an Access table import with memo format. The text memo is long, probably on average between 1000-2000 characters. I have set up the text box to automatically resize for the text, but the text stops at what I assume is 255 characters, even though cell B1 displays the entire memo.
How can I set it up so that this text box (or any other similar shape) displays the text and retains its resize/wrap property?
This is done in Excel 2010.
How increase Sheets number+1 for all Sheets with Vba?View 10 Replies View Related
I need a formula that will calucalte the monthly total based on the following conditions:
Col A = Yearly Cost
Col B = The number of the month when the costs are starting (1=Jan etc)
Col C = The duration or the number of months for which the costs are to spread
Col D is Year 2013 with the months across columns D-O. Row 1 above those columns shows the month's corresponding number.
Right now I have =IF($B3<=D$1,$A3/$C3,0) however if my start month is 1 and my duration is 5, I need the costs to stop after May. I've attached a sample file. Calculate based on start month and duration.xlsx
I'm making a Excel 2013 spreadsheet that has formula in a column that auto enters a number 1-40 when something is entered to the left of that cell. There are 300 rows in the spreadsheet. I would like to make a drop down list in a column cell to the right that would delete that number in that cell from the drop down list. For example cell C1 has 39, that 39 then is deleted from the drop down list. C2 has 22 in it, click on the drop down list cell and it shows 1-40 less 39 and 22.View 11 Replies View Related
Designated Cell = 7
1 10 .034
15 25 .072
35 45 .089
Output Cell = ???
I am trying to find a formula for the output cell. Suppose the designated cell = 7 due to formulas above it. So that number is always given but can change. I then need a formula for the ouput cell that says if the designated cell is greater than or equal to 1, and less than 10, then the output cell should equal .034. So suppose the designated cell = 18.2. Then I would want the output cell to be .072 since it is greater than or equal to 15, and less than 25. The template I am using has 23 rows of numbers like above. I didn't know how to do it for 23 rows though. If/Then doesn't work because it is 23 statements long (well over the seven limit) and the vlookup only works when the cell is equal to a number and not a range.
I'm trying to use the formula vlookup, but running into trouble. I'd like to use =VLOOKUP(3000&A1,E:F,2,0) but this isn't working correctly because it doesn't recognize "3000&A1" as a number? Is there a way to do this? This will be used in a VBA code, so I prefer the solution in VBA, but either way is fine. See attached for more info.View 4 Replies View Related
Is it possible to write a formula that skips x number of cells and have the formula autoincrement as usual. For an examples lets say I want to skip 3 cells and I have entered in the cells listed:
Then I type in the simple formula in the cell
and then drag down but it skips 3 cells so then
If it didn't skip then
this is just an example as I will be writing more complex formulas and need some thing that I can write into the formula so that it skips.
Something similar to this B1 "=A1(skip3cells)"
Having an issue with copying down.
Workbook 1 has data vertical
Workbook 2 has data horizontal
I need the formula in Workbook 1 to pull from the respective date in workbook 2, or just a simple formula increasing the column by 1 for each row.My issue is that when i copy down, the column never increases, it stays on the same one.Example is attached.
if it is possible to increase one cell by 1 when the date was changed in another cell. I installed the code that was given to me and it worked perfectly, thanks agin JB and royuk, UNTIL the cell that was to increase by 1 was locked and the sheet protected.
The date cell is not locked.
I have attached a spreadsheet, in which I have highlighted the following cells (I2, J2, G31 and I31)View 7 Replies View Related
I have a sheet comprising of 4 columns, laid out like the below ;
A4 = Equipment
C4 = Cost
E4 = Revenue
G4 = Gross Profit
I require to enter a percentage into the gross profit column, and for this to interact with the cost column, then for the revenue column to return the total of the cost including the profit.
I'm dealing with the following problem. Say I have a set af values:
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.
in getting the formula right for this:
I have a value which I want to increase with 1,5 % of last calculated value (the initial value is 40 in the example below).
I only need 20 iterations.
I would like to add Cells(18,3) also along with the below code which should increase its existing value with 1.
R = Sheets("Sheet2").Range("B65536").End(xlUp).Value + 1
Cells(15, 4) = R
I need to increase the cell value on a spreadshhet that contains over 50,000 cells. I know how to do this on a cell by cell basis. I need to know if there is some way of doing this to multiple cells. Here is my example;
I need to increase each cell value and roundup to the next number. I have been doing the following formula: =ROUNDUP(603/.97,0) to increase the cell value to $622.