percent

I'm looking to calculate the percent change in time. I have time as 1:14 and 2:05. I guess I can format it any way needed (do I need to format it any specific way). I also converted it to minutes. The formula I'm using is..... (new value - old value )/old value * 100 =((J16-J15)/J15)*100...

Columns D-J contain values currently in the percent format. Changing format to number, updates it to .08 for instance. I know I can multiply by 100 in another cell, then copy/paste... but is there a better way to accomplish this? Tia

I work in a church and I'm trying to determine how to monitor if our rooms with kids/teacher ratios go over the state requirements. For instance, we can have 4 infants with 1 teacher. So, one of our rooms had 5 kids to one teacher and I would like column C to show YES if it is greater than 1:4...

Hi All, I have been modifying a project spreadsheet and have a small issue. I'm using the conditional formatting with a formula that uses the percentage in another cell and the date range in other cells to colour milestones up to a certain date. It's seems to get to the milestone date only when...

Question if i have cell A1 and cell A2 merged together with wrapped text, and i want to increase each individual number by a certain percent how would i get that done for ex. $100.25 ZZ $200.25 ZA through excel VBA

I have a grade book for a school. It is shared online for teachers and staff to use/edit. Due to the number of formulas it can get kind of bogged down. So I am looking to save some processing power and accomplish the same task. A teacher enters a percent in cell then the cell below has a...

HI Everyone: I need to figure out Number of 5 Star Review required in order to increase Average rating (Column G) to Target 1 Average Rating (Column H) Currently I have the formula in column G, and when entering a value in Column I, the average in column changes. See 2nd table for example. I...

This should be easy, but I keep messing it up. The quizzes in a class I'm teaching add up to 60% of the grade. The exam counts for 40 percent. Suggest a formula? Student has a 65 average for the quiz portion, 36 for the exam. Thanks in advance.

I am attempting to generate a ranked list of values based on two conditions; percent and count. The end goal is for me to be able to produce a graph whose values can be changed dynamically by altering two fields. The source data has a list of values, each one with a count (Column H) and a...

I am trying to figure out how to set up an excel calc to allow a user to enter a percentage or amount (see red text below) in adjacent cells to calculate a new value. If they enter a percent, it automatically calcs the amount and vis versa. It needs to be dynamic enough to go back and forth...

Is it possible to create a chart like this in Excel? I was thinking making a bunch of individual charts and overlaying them with transparency and resizing them so they match up might work. But if there is a better way I would appreciate some assistance please. You see it is based on date across...

Hi all. I'm using the Gantt Project Planner template. I know how to edit the defined custom formatting. My question is whether I can go a level further. For example, rather than just the one color showing the percent complete, if I add another column that shows the status, can I have the...

Greetings, I have a bar graph with the y-axes expressed in percent. The minimum percent value is always 0%. However, the maximum percent value can exceed 100%. Sometimes, depending on the data, if I set the y-axes maximum scale for Auto, the chart may have a scale that is less than 100%. I...

Hello, I am seeking assistance in writing a macro to help me line up data. The attached Excel file shows an example of what I have and what I want. Columns A:C are from 2017. Columns D:F are from 2018, just pasted next to it. I have the same variables in each year (Variable1, Variable2...

I have FIVE data numbers for a chart (Four are numbers and one is a percent) I am trying to have JUST the percent show on a Data table. Is this possible? Thank you for your help.

Hi all, I am looking for vba whereby i can filter 10 percent of data for audit percent randomly. can anyone suggest the vba code for the same

By default, for 3 icons, Excel calculates the 67th percent and 33th percent. 67th percent = min + 0.67 * (max-min) = 2 + 0.67 * (95-2) = 64.31. 33th percent = min + 0.33 * (max-min) = 2 + 0.33 * (95-2) = 32.69. A green arrow will show for values equal to or greater than 64.31. A yellow arrow...

Not sure where to even start on this one - hopefully someone can help direct me. I need to look up a person (i.e. Agent: 63517 Acker, James) then from there, find the section called "Total for xxxx" (i.e. Total for 63517 Acker, James), the find "Available and pull/get the Percent in Adherence...

Hi all, I'm trying to get cell P11 to gauge a percentage from a figure typed into cell O11. O11 = a percentage, to 2 decimal points. There are five ranges that O11 will fall into: <35%, 35%-45%, 45%-55%, 55%-65%, 65%+ There are weightings attached to these ranges: 1.5%, 3%, 4.5%, 6%, 7.5%...

I can't believe you can't just add percentages with the usual =SUM(A1:A10) formula!!! The percentages I want to add are all created by formulas, not typed into the cell itself. The total percentage at the bottom of the page is adding up the individual weightings from a number of entries. How...