percentages

You would think this would be easy but its not. I have a column of percentages that shows annual change in items. Given that there are a lot of new items and dropoff items, I want to leave those percentage changes blank. However, I also want to filter on these percentages. I put in error...

Hello All! I can't remember how to utilize percentages in Excel. For example, I have 10 dummy clients, 2 dummy clients have viral load results equal to or less than 20.... I know basic math would be 2/10 * 100 = 20 (20%) So I Excel, I entered this in a cell: =2/10*100 And I got 20...

Hello, I am trying to include conditional formatting such that positive percentages receive green arrows(2-4+%), moderate growth percentages (0-1%), and negative percentages receive red arrows. However, for some reason - some instances of negative percentages are showing up as green arrows. I...

Hello, I have a chart that updates based on the drop down selection of accounts. The problem I am having is that some of the data is in percentages some in regular number format (wide range of numbers). The VBA seems to work for most of the data but when a selection is made were the data is...

So I am in a predicament. We have orders that range from $500 to over $500,000 and we charge a certain amount for an extra condition and we want to base that cost off a percentage of the order. The smaller orders we charge 2% and the max we will charge will be 0.5% at $500,000. Anything in...

Hello everyone! I have a scoring sheet that has a answer key of either: Yes, No, N/A. At the bottom it automatically calculates all of the Yes answers and it will give them a score. To get a 100% score you must get 53 Yes's. What i'm trying to create is if N/A is put into the cell the...

I need to take scores from 6 candidates that their scores or totaled in a row. I need to find the 'points less than the highest score' in that array and also I need to find a 'percentage less than the highest score'. I have attached a clip of the sheet that I am working on a thanks in advance...

Im trying to create a Purchase order form, amongst other problems I'm facing, the one I'm trying to tackle at the moment is as follows, I'm trying to use letters as 'code' for Tax percentages, take a look at the following so after i have entered the quantity and the unit price, the 'amount'...

Hey, guys. Thanks for stopping. I was hoping someone could tell me what I need to do to fix this formula so that it pulls the VALUE portions in a 3 decimal format. Fields G9,D10, and J24 will all have percentages in them in three decimal places. When I'm CONCATENATE-ing, I'd like the value from...

Hi, Im trying to use an "if then" statement to show if a number is larger than 2% of 1,500,000 or smaller than 2% 1,500,000 then FALSE, if in-between the rage then TRUE. In other words, if number is within the range of 2% of X - the statement is TRUE and if outside then FALSE. Any...

I'm not an Excel novice, but my brain is just not seeing how to appropriately do this. I'm hoping maybe there's a function I've never used before, so I'm not aware of it. Or maybe I'm simply too close to the problem and not thinking outside of the box. But either way, my issue is follows: In...

We normally report sales as Total Goal & Total Digital Goal against Total Actual Sales & Total Actual Digital sales, weight both at 50% add them together then take that percentage and give a base percentage with an accelerator for any amount over. For example: <tbody> Goal Actual % to Goal...

So I have setup a dynamic excel spreadsheet that refreshes from MS Dynamics CRM using a simple SQL query (all setup at the touch of a button from MS Dynamics). I have setup a number of opportunity "health" indicators that simply look at the data and highlight potential problems within the...

I am working with calculations that result in percentages (Rate = Commission / Sales) based on sales and commission for several products. I would like to take the results one step further by determining the contribution that each product makes to the total rate, i.e. I need to be able to...

Hello all, First time questioner on this board. Let's say I am putting my formula in A1 Sheet 1. The formula I have references cells on other sheets in the workbook. For example, the formula in A1 Sheet 1 reads ='Sheet2!'A1 and thus shows the number in A1 Sheet 2. Ok easy. Now, suppose that...

I saw this once, but can't remember how it's done. If I have an investment that returned the following in three years: 2.3% 4.6% 9.5% . . . my compound return is 1.023*1.046*1.095 minus 1, or 17.17%. If I have those three percentages in Column A, I usually create a formula in Column B to add...

Hey there, So I have a Pivot Table which has a few slicers. I want to insert a field that shows the % count of the total amount... Example - lets say I have a column of data that is the following colors: red, red, orange, orange, orange, yellow, yellow, yellow, blue, and blue. When I select...

Hi, I'm facing a real problem... and I just cannot seem to find the answer / solution for it (if there is one). I'm not quite sure how to best explain this, thus I have the below image to help. In essance, I need to buid a pivot with % (showing the leftover or usage of something). All in all...

Hello, I have a Pivot table in which I have Grand Total for rows as Sum. I want to add another Grand total with percentages BUT I need the percentages only in the Grand Total and not for each column within the table (Which seems to be the default). Any idea on how to solve this? Thanks, D

Hi, I'm building an excel sheet on a games project I'm doing. I have found the breakeven number by dividing my cost of sales by an average sale price, however, I would like to be able to show what kind of split it would be, i.e. 12000 of the £3 game and 20000 of the £20 game. Anyway this can...