percentage

Good day. I'm busy with performance reviews for staff but are battling with the following. Section 1 for instance gives me an achieved percentage of 80% and the weighting for this section is 50. Section 2 has a achieved percentage of 40% but the weighting for this section is only 30. Section 3...

Hi All, I am wanting to create a formula that calculates a fee dependent on the value of the sale. Where Cell A1 would be the value of the sale 0 - 29,999.99 Capped $500 30,000 - 49,999.99 2.5% Capped $1,000 50,000 - 99,999.99 1.9% Capped $1,500 100,000 - 149,999.99 1.5% Capped $2,000...

I have the following cell data. A2 = 108.59 B2 = 20% C2 = 27.15 C2 has the following formula in it: =A2/(1-B2) - A2 this gives me the 27.15 What I want to do is have in D2 a hard value of 23.00 and then in E2 I want the % value based on the formula in C2. IE - If C2 was 23.00, what would B2...

I have a column of numbers (in percentages) which is a part of a pivot table. I need to color code this column as follows: - Percentages above 95% "Good" - Percentages >= 90% and lower than 95% "Neutral" - Percentages < 90% "Bad" I would like to use Excel Styles for colors. I have written...

Column I in my excel file shows unpaid invoices. Column K shows uninvoiced items. Column P shows the customer's balance on account . Most of the time, P should be greater than I+K. However we want to be able to easily spot the customer files that are close to or have exceeded the customer's...

After applying discounts (x%,2x%,3x%) to premium, the final discounted premium price is 1.1 million. But maximum final discounted premium price that I can give is 1 Million. Now, how to adjust the discounts (x%,2x%,3x%), so that my final discounted prices is exactly 1M Note: I have to use only...

Hi all, I have attached a screenshot of what I want to do. Essentially, I want to populate Column G with numbers which relate to percentages in Column J, they are percentages of the number displayed in cell G28. I found this hard to explain so if you need any more information, please let me...

Hello, I have a Pivot Table with Years as the top-level column, then two fields underneath, Cash and Operations. The values in each field are currently calculated as % of Parent Column Total, so Cash and Operations are shown as percentages of each year's total. I would like to also create a...

Howdy all! So I am trying to figure out how to make this idea a reality. I'm not even sure that I can but I figured I would ask the web of experts and see instead of screaming silently in my head over and over. Idea: I want to be able to calculate the percentage of vehicles in my squadron...

As shown in below Table. "F" has sold 2 items out of which one is defective. i.e. 50% of what he has sold is defective. How do i represent this in Pivot Table? I am unable to figure out the Layout. Raw Data: Sales Executive Products Sold Defective F XYZ NO D XYZ NO F XYZ YES C XYZ...

Hello, Which is the correct way/formula to convert the currency cost into a formula. For example: $39.21 shows as 3921% - May I know which formula I should use to get the percentage in a correct way. These are the sub-totals cost I have and I would like to show them in a percentage form...

I'm working on a time study. I need the formula to convert numbers of hours worked on a task in an 8 hour day into a percentage.

Good day, I know I can make this simpler but I am sending this out to the world of the company and need to keep it "concise". I need to have a value "score" selected based on % given however, the options to pick the value "score" needs to be obtained using the range below A B...

Good afternoon everyone, I'm thinking this is an easy question but I'm having a brain fart and can't figure it out. Basically I have a spreadsheet where I need to have a red light whenever the percentage is less than -8% and a green light whenever the percentage is more than 8% and have no...

I better explain this right, i would like to present in a cascade chart the participation of a category in the percentage fraction out of goal. Any guide will be highly appreciated. From the table below in PowerBI I have the following: On Goal = 8/18 = 44% What i would like to present is the...

How to distribute the value of 30 with the following Percentage: A 19.6% B 13.5% C 15.7% D 3.2% I want to get the same value of 30 for A,B,C& D

This formula is supposed to test if one cell value is less than another, if so, show nothing, if not, then do a percentage calculation and show that, what am i missing? =IF((AZ2<$AX$7),(""),(("BA2/AZ2)*100"))) Happy to share the spreadsheet if it helps, it's nothing personal. Here's how it...

I know the exact % I need to achieve. In this example column G2 is the target % of 67.201%. G2 = 67.201% (This is the target %) D4 = 4,250 (This is the number I need to increase to meet the percentage. The amount I need it to be is 4,681 for a difference of 431) As the percentage of G2...

hello, i would like to know if i can preserve excel cell format when using any lookup formula, i have a chart and want to view sales by quantity/value or percentage based on slicer selection. the method that i’m using currently allows me to view any of the above with 1 type of format not based...

We have a macro that reviews all the formatting of one spreadsheet against another spreadsheet. My problem: If spreadsheet "A" has a percentage formatting of 0.00% and spreadsheet "B" has a percentage formatting of 0.000%, when entering the results in a separate "Results" spreadsheet, Excel...