Percentage Of A Text List?
Jan 24, 2014I have a list of prey for different fish feeding and I would like to know how to calculate the percentage of each prey.
View 2 RepliesI have a list of prey for different fish feeding and I would like to know how to calculate the percentage of each prey.
View 2 RepliesIf I have a drop down list created that contains each state, is there a way to correlate a value (%) when that state is selected that would be able to be used in formulas created in other cells in that row? And how would I go about creating that?
View 1 Replies View RelatedList Price $46.98 (e2)
Net Cost $19.53 (e3)
How do I enter a calculation that will show me my discount percentage from my supplier? (e4)
I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item.
I need to convert my percentage marks into values based on competency values. Once again my school board has change the final reporting method. Last year we had to use A, B, C, D. This year it is based on scales of 1- to 5. Since excel cannot have more than 7 nested IF statements I was wondering if anyone knew of a way to have a percentage mark converted into a scale number. Below is the following data.
0-5% = 1-
06-15% = 1
16-25% = 1+
26-35% = 2-
36-45% = 2
46-55% = 2+
56-59% = 3-
60-64% = 3
65-70% = 3+
71-76% = 4-
77-82% = 4
83-88% = 4+
89-94% = 5-
95-00% = 5
I have the following text in B5 "deposit fee 0.75%". I have a value of 3500 in B2. I would like a formula where a can multiply the value in B2 x the 0.75% that is contained in the text "deposit fee 0.75%"
I tried to use =B2*VALUE(MID(B5,17,1)), but it gives me #value
I have a list in column A of percentages (to 4 decimals 0.0013) i need to conditional format the list so that it shows the lowest percentage in 'green' and the highest in 'red'.
View 5 Replies View Relateddistinguish text or value in a textbox with "%"? (e.g. input 7% or 0% is TRUE but input "" or 0 or 0.07 or or 7$ is FALSE)
View 4 Replies View RelatedI am having problems with a macro I wrote that basically fills things in two columns based on a set of values from other columns.
Lets say it looks like this (column B is based on column A):
A1 = Hi
A2 = Hello
A3 = Hi
A4 = Hello
A5 = Hi
A6 = Hello
A7 =
A8 = Hi
A9 = Hello
A10 = Bye
After the macro runs, column B should look like this:
B1 = 10%
B2 = 20%
B3 = 10%
B4 = 20%.............
I have attached an excel sheet and I want to count and report frequencies the amount of X that are occurring from the 'CSR1' book in a table in the 'Frequency' book.
The CSR1 book has 4 sections and I need to formula to adjust the total percentage accordingly if only 1, 2, 3 or 4 sections have been populated with data.
Please see attached.testdata.xls
In the attached workbook i need to take out the % numbers from the text to populate the cells.
the Pay % cell is the % before the / and the receive % is after the /.
I have a spreadsheet that tracks in column D "completed" projects. I want column T to populated "100%" when column D has the text "completed" in the cell. What is the formula?
View 1 Replies View RelatedI have a list of YES or NO answers in a sheet. I want to calculate the % of YES in the list. E.G. if there are 100 cells in total and 25 of them say YES and the remaining 75 say NO, the percentage should be 25%.
View 2 Replies View RelatedI have a user form which includes some text boxes (txtRUL.text for example) where I want to enter a number as a percentage. I divide the number entered by 100 to avoid Excel automatically multiplying by 100 and the result is displayed in the user form as the correct percentage.
Private Sub txtRUL_AfterUpdate()
EnableSave
txtRUL.Value = Format(txtRUL.Value / 100, "0.0%")
(I'm sorry I cant figure out how to format this code as code in this post)
This works well, trouble is when I save and it writes the results to the worksheet, the numbers in the user form revert back to plain unformatted non percentage numbers (ie 5% goes to 0.05)
I have a form in work which acts as a tick sheet for tasks complete on a construction site. When a task is complete I copy & paste from a key of dates i.e. week ending 11.05.15, this allows me to see what week a task was complete.
Generally I only marked off tasks which were 100% complete but my manager wants me to enter the % of the task complete also, i.e. 80% in the box.
So my question is how can I have the formula assume that any box with a date & shading is 100% and any cell with a number i.e. 80 is only 80% complete. I need it to monitor around 150 cells and give me the overall % complete based on what i have discussed.
I would like to be able to compare the "standards" in Column A with the Assessment status in Column B and the Assessment period in Column C in order to generate a compact list in another workbook (ideally) or tab (if not). A list might typically contain all the standards that have been M (mastered) during a given Assessment period. I realize that filters would achieve this to a large extent but I was hoping to automatically populate another worksheet or tab.
View 3 Replies View RelatedI 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.
i want to do is, have a list that picks from a color and then beside it, it will show the possible fruit that is that color for example
Red
apple
cherry
strawberry
OR
Green
watermelon
grapes
The number of fruit will differ by the color so i know i need a counter there, but i am not sure how to list the fruit after i've picked the color
refer to the attached workbook for reference. I am looking for a function in Sheet1, Column E that will search for the value of Sheet1, Column A within Sheet2, Column A. When a match is found, the function should look across Sheet2, Columns B - V for values of 1. When such values are found, the function should return the associated value from Sheet2, Row 2. There may be multiple values of 1, and as such, the function should separate values with a comma.
View 3 Replies View RelatedEasy way to find the drop down list , if more than 500 list. at least the very first letter of the text.
View 1 Replies View RelatedI have two lists.
The first:
P1116
MC1070
BD1068
I want to check if any of these values are contained in the text of each item in the second list, that looks like this:
64K4014-4" , 64K1030-4"
64P1116-3"
64P1187-4" , 64p1117-4"
64P1330-2"
64P1405-2"
64MS1007-0.75", 64MC1070-2"
64K1062-3/4"
64K1061-0.75"
64CW1062-2", 64BD1652-2"
64NG1007-1 1/2"
64K1008-2", 64BD1041-1", 64BD1068-2"
64HS1002-6"
64HS1002-6"
64CW1068-2"
I tried using the =search() function in an array formula, but I can only get it to work for a single value in the first list.
I am trying to write a function that will compare the text of cell "A2" to the text of cell "B2" and display cell "A2"'s text characters that didnt match from cell "B2" in column C. Can anyone help me out with writing this formula?
EX: ....
I have a sheet in which some of the cells have two strings separated by a linefeed. I have come up with a cumbersome formula which will let me check if either of the two strings is a member of a list stored on another sheet. However, it fails if there is only one string in the cell, presumably as there is no linefeed for the formula to find. How can I modify the formula to cope with this situation?
There are also on occasions, three strings in the cell, but I can't seem to access the middle string with the formula. Simplified spreadsheet attached to show the problem. This must be formula-based, as we have a no VBA policy. If you think there is better way of doing this, please let me know.
calculating the percentage of a percentage and writing the formula for excel.
There are 295 people in a room, of the 295, 75 or 25% are mothers. (I know how to calculate 25% - 75/295 = 25.42) of the 75 mothers 35 have 3 children, 32 have 2 children and 10 have 1 child.
35 is what percent of 25%
32 is what percent of 25%
10 is what percent of 25%
I have a range that contains text. Let's say the range is colums $F:$M. There is x rows and in each cell there is either nothing or a word, let's call it "dummy". There is just a certain amount of "dummies", such as "dummy a", "dummy b" and so on, let's assume ten different dummies. It can also happen that "dummy c" or any other dummy appears more than once in those colums.
What I want Excel to do, is looking up columns $F:$M and make a list (possibly sorted) that includes all the entries from columns $F:$M, but each one only once and no blanks. Can I do this and if, how?
I am trying to add a text list, so that the value returns the number 1 in a cell regardless of what name is entered from the list i.e. =IF(B4="Smith""Townsend""Velez""Willer",1,0)
List
Smith
Townsend
Velez
Willer
I am currently using a pivot table to display data. At the moment, as you can see from the spreadsheet I have something that shows land use, suites and costs. how to calculate a total cost - but only counting each suite once.
I would like to do similar thing for the bottles required, this is based on information from background! I am hoping get something just like the way costs are generate, by only counting each bottle once.
I have form with a list box lstEmpName which is populated from a sheet "Records" range a1:a35. This is in the UserForm initilize sub.
When a name is selcted I want the corresponding payroll number (found in Records range B1:b35) to auto popuate the txtPayroll box. I've had a go at some code but it's not working in the Userform Initialise sub and I don't even know if this code would work.
txtPayroll = Sheets("Records_LookUpList").Range("B" & lstEmpName.ListIndex + 1)
I have an excel list in one column of all my AP vendors and I want to add text to the bottom of the vendors name, such as:
Currently looks like this:
Office Depot
Staples
Orchard Supply
I Would like it to look like this:
Office Depot
FY 09/10
Staples
FY 09/10
Orchard Supply
FY 09/10
So basically I want to add the FY 09/10 to the bottom for the entire list of vendors. On top of that, all though it's not a critical, I would like to have the FY 09/10 be a different size and boldness.
this is to do a mail merge for labels in word
I want to write a formular to initiate an action if a particular text is not in a list For example, I have a list in column D1:D50, and I want the following to happen in say cell A1
If "apple" is not in list D1:D50, then in put "N" in cell A1, else input "Y".
I have been trying to put together some VBA code that will look for specific text in a range from a list of approved words that I would like to bold. I found some code on the web, and have modified a little bit, but what is happening is that I am only getting items that aren't on the list to bold instead of the items on the list to bold and no other text.
Here is the range of text that I want to be searched on Sheet1
******** ******************** ************************************************************************>Microsoft Excel - Book1.xlsm___Running: 12.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutC8=ABCD1Text 2List 33 4Something 5Test 6More Text 7Another Item 8Etc 9Another Test 10Run 11Home Sheet1 [HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
And then the "List of Terms to look up" on Sheet2
******** ******************** ************************************************************************>Microsoft Excel - Book1.xlsm___Running: 12.0 : OS = Windows XP File Edit View Insert Options Tools Data Window Help AboutA1=ABCD1Text 2List 33 4Something 5Test 6More Text 7Another Item 8Etc 9Another Test 10Testing Sheet2 [HtmlMaker light Ver1.11] To see the formula in the cells just click on the cells hyperlink or click the Name boxPLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR........................