Increase Percent In Cell If Other Cells Contain Data?
Oct 24, 2013
I'm trying to track how complete a project is by checking if cells contain data, and if they do the percent in cell 'Y4' would increase.
I have 6 cells which represent milestones and if they contain data then they would add a certain percent to cell 'Y4'.
Cells B13 & R13 would have a weight of 15% each
Cells J13, J21 & J30 Would have a weight of 20%
Cell L34 would have a weight of 10%
Is there any way that if these cells contained any data that I could add that percent to the total in 'Y4'?
View 2 Replies
ADVERTISEMENT
Apr 15, 2008
Formula for figuring retail price from cost. ie Cheeseburger 1.00 cost and I want a 60% markup. (2.55 Retail)
View 3 Replies
View Related
Sep 12, 2012
I have a percent 3.14%, that I want to show 15, 20 and 25% above and below that percent. I am showing below the results and then formula. The top calculation results in the same on both the left and right. However the -15,-20, -25% results are different. Which is correct.
3.14%
20% +/-
3.14%
0.63%
or
6.28%
1.57%
2.51%
[code].....
basic math, but I don't understand why the results are different.
View 3 Replies
View Related
Jun 18, 2013
I am copying from a cell that has 100 (number stored at text) and want to display in a number format (100%) I keep getting 1000%. I've checked the format to ensure it has 0 decimal places. I've tried formatting the cells as a percent. Still no luck.
View 5 Replies
View Related
May 15, 2014
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:
Sub Macro3()
'
' Macro3 Macro
'
'
Range("g10").Select
[g10] = [g10] + 1
[Code] .......
View 2 Replies
View Related
Apr 14, 2014
I'm calculating meter data in 5 min intervals B column is primary meter data C column is secondary meter data B and C are averaged in D using
=AVERAGEIF(B3:C3,">0")
I'm using AverageIf ">0" because one of the two meters is regularly removed from service for calibration, in which case I don't average, I'll only use the online meter reading.
Now I have to figure out how to average B3 and C3 only when the deviation between the two is <10%, and or if >10% to use the greater of the two values.
The examples are B12, C15,18,19...
View 10 Replies
View Related
Jun 10, 2013
I have a data entry field on a form that is formatted for percentages. Sometimes when i key in "10" it will correctly convert it to "10%" but other times it randomly converts it to "1000%". When the error occurs, I'm able to correct it by re entering the value a few times until it displays correctly as "10%".
View 2 Replies
View Related
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
Mar 8, 2009
Can someone tell me it is posible to increase cels value (diferent values) from D2 to D21 for example, by 20. I just start to use excel.
View 6 Replies
View Related
Sep 25, 2013
My cells will not always increase in size with text wrapping.
Especially when I copy and paste from one sheet to another. I have formatted and re-formatted and re-formatted.
View 2 Replies
View Related
Apr 5, 2013
Any way to have the date auto increase 7 days when we drag/copy down the cells. For example, I have the following:
03/31/13
04/07/13
04/14/13
So, when I copy down (let say hundred cells down), the day should show 7 days apart. Is there a formula?
View 3 Replies
View Related
Feb 10, 2009
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.
View 10 Replies
View Related
Jun 6, 2006
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;
$603
$712
$649
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.
View 9 Replies
View Related
Jan 19, 2009
If a cell is not blank, then increase that amount by a percentage identified in another cell and display the value only without any formalas in a new cell. To this end I wrote this IF statement:
=IF(I2>0,CP9=(CA9*I2/100)+CA9,CP9="")
Observation: I see a FALSE in CS9 where this IF statement exists, however, CP9 does not display the required value.
View 8 Replies
View Related
Dec 28, 2006
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
Item Reference
Orange R9
Orange R9
Orange R9
Apple R10
Apple R10
Apple R10
Mango R11
Mango R11
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.
View 7 Replies
View Related
Sep 17, 2007
I having been looking at ways of increasing the width of a data validation list (drop-down) to accommodate items longer than the width of the target column. I found a solution here http://puremis.net/excel/code/068.shtml
The demonstration seems to do exactly what I require. However the code supplied does not work for some reason. I have run the code in debug to see what it is doing and the code runs until it gets to the line
Set objDic = CreateObject("Scripting.Dictionary")
from here it just jumps to the end of the procedure. Mousing over objDic says ObjDic = Nothing.
I am getting a bit out of my depth here - anyone know why objDic is not being assigned a value and the procedure bombing out from here.
View 6 Replies
View Related
Jun 12, 2014
Is it possible to have a cell increased by 1 and another decreasing by 1 in a simple cell formula.
E.g.: I have an inventory stock sheet that is very simple. I have a maximum stock column C, a stock on hand (available) column A and a stock sold column B.
Every time I sell an item and punch it into column B it should automatically decrease the amount in column A by the number that I punch into B.
I am not concerned about the maximum stock column but would like an easy formula just to work out the amount that I have available so I know when to order more stock.
So when I punch in a 5 on B2 it should decrease the value of A2 to 1. And when I purchase stock again and I punch in say a 5 on A2 it should decrease B2 to a 1.
****A* B *C
1 *2 *4 *6
2 *4 *2 *6
3 *8 *6 *14
4 *0 *6 *6
View 3 Replies
View Related
Jan 10, 2009
How can I get one cell to increase by 1 after I change the date in another cell. The spreadsheet is used to keep track of Oxygen Bottles at the local Fire Dept. and I want the " Times Filled" cell to increase by 1 after the " Date Filled" cell is changed. I'm not sure if they key the date in or if they use a calender add-in pop up.
View 5 Replies
View Related
Jan 28, 2009
I'm trying to sum a range in Column AB that increases by 1 cell every day.
Specifically, Jan 1 will be AB1, Jan 2 will be SUM(AB1+AB2), Jan 3 will be SUM(AB1:AB3)...and so on...Dec 31 will be SUM(AB1:AB367).
If it helps, the dates of the year run from A2:A367.
View 9 Replies
View Related
Dec 7, 2010
I created a small block of cells on my worksheet where i have in separate cells, the day of the week, the days date and the month. I want to design a special memory calendar for my mom in early stages alzheimers.
There are cells with specific info which i do not want to re type for the whole month/year.
I want to be able to copy all the info into another block of cells and have the day of the week and date change also the month.
View 9 Replies
View Related
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
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
Apr 2, 2007
I'm a novice at macros and spreadsheets and a Visual Basic Virgin!!.
I'm trying to work out how to increase a cell (B17) value from 1 through 5 then jump back to 1 and count to 5 again etc etc.
The value should be incremented every time cell B33 ="Yes" however there needs to be a 2nd event which resets the B33 trigger to operate again.
This is when cell B34 shows "New Race"
View 9 Replies
View Related
Apr 8, 2008
I have to reference to another sheet a fixed increase of moving 6 rows across. What would be the formula for it?
For example.
First formula would be =Sheet1!A1
What would be the formula for the subsequent cells. (eg. =Sheet1!A1+6) obviously doesn't work.
View 9 Replies
View Related
Jul 27, 2007
Is there a function in VBA that lets me increment or decrement the number of decimals of a particular cell? let's say i got a cell value of 7.123456 but excel only displays 7 on the cell. What if i want excel to display only 7.123? How can I specify the number of decimals i want on a particular cell (in this case 3)
View 2 Replies
View Related
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
May 9, 2012
i'm looking for a loop macro to perform the following task:
Sheet 2 is my look up table, and sheet 1 as a number of references such as:
='Sheet 2'!B1
='Sheet 2'!E1
='Sheet 2'!G1 etc
I need a macro that increases the row references "1" to "2", saves the sheet then increases "2" to "3" and so on until the bottom of the reference table is reached
View 1 Replies
View Related
Nov 17, 2007
I don't know if I am asking for something impossible,but is it possible to create a MACRO to automatically add or subtract 10 to whatever number is in the cell? for example:
A1= 20
I would like to have a macro that lets you either add 10 to it to become 30 or subtract 10 to it to become 10.
View 9 Replies
View Related
Aug 22, 2008
I have 22-08-08 in Cell A2 I would like it to change to 22-09-08 on 23-08-08 ideally using edate (but not neccessarily).
Perhaps I can add a formula with conditional formatting eg formula is = "On Today()+1 Add 1 month to cell A2"
View 9 Replies
View Related
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