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.
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.
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:
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.
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%".
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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"
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)
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.
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
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.
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 ....