Have Cell Return Percentage Of Another Cell
Apr 8, 2014How do I have cell A1 display 20% of cell B1?
View 3 Replies
ADVERTISEMENT
Increase That Amount By A Percentage Identified In Another Cell And Display The Value Only Without Any Formalas In A New Cell
Jan 19, 2009If 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.
Conditional Formatting Based On Percentage And Insert Cell Based On Percentage
Apr 3, 2013I have a workbook that I've built for a project. I've attached a sample workbook. What I'm trying to do, for the entire sheet or workbook if possible, is turn any Cell with a percentage of 30% to 49% yellow and any cell with a percentage of 50% or more Red. I would also like to move the ID's of the variable cells, for example Id number 9922, to the cells beside the description of the rows, Affected would be an example, if the information contained in the same row as the ID meets with a set of variables.
For example I only want the ID's moved if they correspond with IDsub 1-25. One more thing, the people who will be using this spreadsheet will be copying data from a website when it is imported it does not insert the values as numbers. I would like to format the cells, in example workbook they would be any of the cells labeled ID IDsub Variable or Number, so that anything put in that cell will automatically be converted to a number.
I should also probably add that the formatting will be done on approximately 80 rows a sheet with 47 sheets.
How To Match A Cell Data With A Range Of Cells And Return Cell Reference In Another Cell
Dec 12, 2012i want to match a cell data with a range of cells and if matches return the cell reference in another cell
View 3 Replies View RelatedTwice Percentage Cell?
Dec 16, 2013The cell I am referencing value is 100,000
I need to take two percentages off of that number. First 50%, then 37% and have the value in a SINGLE cell.
Because 100,000/1.87 is not the same thing....of course.
Cell Containing Number And A Percentage
Jun 26, 2006Is there any way to make a cell display both a raw number and a parenthetical representing a percentage based on a formula? I know this may sound strange.
Examples:
9 (25%)
12 (39%)
I could get it done via merging or =_&_ style entries, I know, but is there any other way?
Return Percentage Of Number Based On Its Value
Sep 8, 2007Spreedsheet on on sales and taxes
Need formula for cells.
3 different cells involved... B1 will have $ amounts, B10 tax code, B25 will have total of tax applied due to code.
Exp; cell B10 will contain the tax code... if you enter..... "1" in the cell the calculation will be 7% in cell B25, enter "2" in cell B10 and the calculation will be 6% in cell B25 , and if you enter "3" in cell B10 the calculation will be 13% in cell B25.
Percentage Increase Or Decrease From Cell
May 2, 2012I 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.
Display Zero Percentage In Single Cell?
Jun 25, 2012I would like to display the zero percent (0.00%) value in a single cell on a worksheet. Typically, there will be a positive value input in the cell such as 3.50% but occasionally it will require a zero value. When I type the zero value, the cell is displays a blank. I do not want to show zero values on the remainder of the worksheet.
View 2 Replies View RelatedAdd Modifier Cell To Percentage Formula?
Oct 1, 2013here is the formula I am using. =IF(A5 < =Schedule!$K$9,100%,0%) We only track complete and not complete....so my formula above just comes out to 100% or 0%. What I am wandering is if I can add a modifier so that it can be adjusted w/o just over writing the formula. Ok so my vision is, the formula above is in cell B5.....next to it in cell C5 I would like a modifier so that if that amount should really be 85%. I can type 85% in C5 and it will change B5 to 85%. So I guess the formula would be more like =IF((A5 < =Schedule!$K$9,100%,0%),or = C5))
View 2 Replies View RelatedTransfer TextBox Value To Cell As Percentage
Aug 26, 2007I have various textboxes and they are entering values onto my sheet on my command.
If i say, enter 10 into a textbox, meaning 10%, on my spreadsheet it comes out as 1000% I thought about being clever and putting
range("a1") = textbox1.value / 100
but this brings up an error with the debugger!
Percentage Of Cell Value To Number Count
Jun 5, 2008I know for some of you this will be pretty simple but im having trouble figuring it out. Attached is a shortened version of what i am trying to do. I want the Percent Attendance column to represent the cumulative percentage(hope I used the correct phrase). So for Person 1, it should currently say 100%, person 2 it should say 66.67% and so on. There are 5 days that i want to get the percentage, but because we haven't gotten to 2 of them yet, using a regular sum formula for the entire five days gives me the wrong values.
View 2 Replies View RelatedExcel 2010 :: Return Percentage Of A Fraction In Row Above
Aug 8, 2012I have row 2 formatted as a fraction and row 1 formatted as percentage.
I am looking for way to return the percentage of row 2 in row 1. I.E. If i have 3/4 in a2, I want it to return 75% in a1. I have figured a formula to return a percentage for numbers with only 1 item to the left of the division sign (i.e., 3/4). That correctly returns 75%. I am struggling with working a formula to also return larger numbers (e.g. 12/15).
I'm using excel 2010......
Return Result Based On Percentage Being Within A Range
Jan 17, 2008I'm attempting to do the following:
A1 contains names of projects.
B1 contains variances from budgets, being positive or negative numbers.
C1 will contain results.
I need to know which of the B1 cells contain a number equal to or greater than 20%/-20% and output the names in A1 that match the criteria to C3.
Add 2 Cells Show As Percentage Of 3rd Cell But Still Allow For 0 Values
May 23, 2013I am trying to add 2 cell values together then show the total as a % of a value in a 3rd cell, however I also need it to allow for 0 values in the chosen cells without displaying an error message or it messes up the average formula elsewhere on the sheet?
View 2 Replies View RelatedAdjusting Percentage Values On Cell Change
Jan 8, 2009Good afternoon Gentlemen, I have a column of data, with a varying number of percentage values that add up to 100%, separated by "NA", i.e.
33%
33%
33%
NA
25%
25%
25%
25%
NA
100%
NA
20%
20%
20%
20%
20%
NA
Now... when I change one of the values I would like the others to even up, i.e. in the last example if I change a 20% to 50% I would like the others to change to 10%... any ideas?
Take Cell Values From Six Worksheets And Adds Them Up As A Percentage
Jan 27, 2010How would I write a formula that takes cell values from six worksheets and adds them up as a percentage (quarterly updates)? I realize this is wrong, but here's what I'd tried (for three sheets).
=+SUM(IF(EVH!F7="Y",25,0)+IF(FUN!F7="Y",25,0)+IF(HES!F7="Y",25,0))/3
Show Numbers Based On Percentage In Cell
Sep 15, 2007I have a rather large report full of data, 10+ columns contain a RANKING column, and these ranks, 1-10, are assigned by a % bracket:
1-20% = 1
21-40% = 2
41-60% = 3
61-80% = 4
81-100% = 5
101-120% = 6
121-140% = 7
141-160% = 8
161-180% = 9
181-200% = 10
There are several hundred rows in each column that all need individual ranks. My first thought is to program a if then else statement for 1 to 10 with a % limit range, but this isnt feasable as i would have to program a separate if statement for each of the many hundred rows, or do one heck of a fancy loop that i just cant contemplate (as the rows are split and sepperated... no solid uniform place for the data to be plugged.) What is the best way to go about this? I'm at a total loss of ideas with my knowledge of excel.
Compare DDE Linked Cell For Percentage Tolerance Of Last Value
Aug 6, 2008I have a DDE linked cell that is constantly updating (cell A1), I want then to have a cell (cell B1) that changes only when cell A1 differs from value currently in B1 by a certain percentage, then check B1 for the same tolerance level against A1, and repeat. I can do this in a number of ways in VB, however when VB code is running causes the DDE link not to update and since the update is constant I cannot use selectionChange and Change VB Worksheet function result in the same error.
View 6 Replies View RelatedExcel 2007 :: Displaying Zero Percentage In Single Cell
Jun 25, 2012My Excel 2007 worksheet contains a cell where a percentage is manually input. A freight cost is calculated based on the input percentage. Typically, the percentage is 3-7% but once in a while freight is excluded and the percentage is zero.
My issue is that when a 0 is input the cell appears blank and I would like it to display 0.00%. The remainder of the worksheet needs to have the zero display turned off.
IF Function To Display A Message Depending On Percentage In Cell
Feb 21, 2007Im currently studying for an ICT A level and im in my first year doing AS. Im working the AQA board and i have a project that i have a target for an A! I need to create a system for a business and write a report on everything i did...wont go into detail. Anyway. i am having trouble with an IF FUNCTION!!! I have a cell (E35) that contains a percentage.
I want the IF function to display a message depending on what the percentage in cell E35 shows;
IF, 0>> Display "Bad"
40>> Display "OK"
70>> "Good"
90>> Display "Very Good"
E35>=100 >>>> Display "Excellent"
I have tried so many things and I was so sure i entered it correctly, but it keeps coming up with an error.
Assign A Score Value To The Cell That Contains A Percentage Depending On A Range
May 2, 2007I have a spreadsheet with several columns that have percentages as a whole number and with a decimal format. I need assign a score value to the cell that contains a percentage depending on a range.
For example:
If cell A1 has a value between 97%-100% then A2 should display "15", however if A1 has a value of 90%-96% then it should display "12" and if A1 has a value of less than 89% then it should display "0".
Excel 2010 :: Return Range Of Cell Concatenated Based On Single Cell Value
Jul 2, 2012I have a range of cells each containing a name. Based on a number that has to be entered manually I want excel to return the names concatenated in one cell. So for example:
Number of variable entered: 5
q9001
q9002
q9003
q9004
q9005
q9006
etc.
Should give me: "q9001 q9002 q9003 q9004 q9005"
I have been trying to work with formulas using IF and CONCAT functions. But so far I haven't figured out how to have excel return me the correct amount of variables for each separate number that can be entered seeing the number of variables entered can vary from 1 up to 50.
(Using Excel 2010)
Cell A41 Is What Percentage Of Cell A42?
Apr 10, 2014Cell A42 is a counta total of cells with values in column A
Cell A41 is a count of those cells which have changed. (manual changes)
I want to know what percentage of the total number of cells have been updated
Basically: Cell A42 is what percentage of Cell A41
Excel 2010 :: How To Return Value Of Cell Beneath A Cell With Specific Value
Jun 14, 2014What I'm trying to do is, create a formula that works like vlookup, except I want to return the value of the cell that is a specified number of cells below the looked-up data in a single column array. So, let's say cell A1 reads "Bacon". In B1, I'd like to put a formula which searches the array for the cell that contains "Bacon" and then returns the value of the cell underneath, let's say the value is "Eggs". Then in C1, I'd like to put another formula which also looks up "Bacon" in the array, then returns the value of the cell that is down two cells from the cell that contains "Bacon", let's say the value is "Milk". And then in D1, a formula that returns the value 3 cells below "Bacon", and so on. All the values here will be text, and not sorted in any specific order. I'll be using Excel 2010.
Please take a look at the attached sheet if it clarifies things.
Return Word In A Cell To The Cell In Next Column - InStr Not Working
Jan 27, 2014I am trying to write a sub for using vlookup. To enable the vlookup, I want to return a word in a cell to the cell in the next column. I use the InStr function, but it doesn't work. They all return as "Other".
Attached is the worksheet and here are the codes : Capture.JPG
[Code] .....
Find Cell Value In Column & Return Text In Adjacent Cell
Jun 10, 2008I have a drop down list in a merged cell B12-F12 and B13-F13 and B14-F14 . . . B30-F30.
I need the adjacent merged cell to populate a reason (text) based on the text answer in the drop down list or the entered text in the first merged cell. For example in the cell B12-F12 the user picks from the list or types in "Amiodarone." I want the adjacent merged cell G12-J12to automatically fill with "Heart Rhythm." I also want to be able to set up multiple if - them statements like if Amiodarone is entered then fill adjacent cell with Heart Rhythm and if Toprol XL then fill adjacent cell with Heart / Blood pressure and if simvastatin then fill adjacent cell with Cholesterol, etc. I have about 30 different options for cell 1 that I want to have auto fill in cell 2 based on the contents of cell 1. I've attached my file.
I want the user to be able to choose from the list or type the drug name in.
Tick Boxes When Ticked Calculate Accumulative Percentage In A Cell
Apr 22, 2014I have a spread sheet with various tick boxes, that when ticked calculate an accumulative percentage in a cell. This cell is the basis of my graph.
E.g. if the cell displays 80% - the chart with show 80% - simple.
However, I want to write a vba code that changes the fill colour of the chart depending on the percentage.
i.e. if the percentage data = 0-49% I wish the chart to display as red. 50-69% - yellow and 70%+ = green.
Lookup Percentage Formula Depending On Price Entered In Cell?
Jan 28, 2013I have the following table in excel:
Price: Percentage:
$150 10%
$100 12%
$50 14%
I'm trying to use the percentage depending on what price I enter in a cell. For example; if I enter $135 then 10% will be used, if I enter $65 then 12% will be used, and if I enter $47 then 14% will be used.
How To Return Address Of Column Or Cell Select Not Just Return Value
Aug 18, 2014How to return address of the column or cell I selected from Application.Inputbox, not just return the value?
[Code] ....