100%

I'm trying to write a formula that returns a % attainment based on a bonus achievement when referring to a target range. The goal range is below from 0% to 200%. if the achievement was 265, the attainment% would be 100% (shown here). How do I write the formula so it calculates the exact %...

Hi Is it possible to do the following in pivot table? Do running total % of row total based on the values of the running total in point 1 <tbody> A B Total 1 2 3 3 3 6 4 1 5 </tbody> Running total <tbody> A B Total 1 2 3 4 5 9 8 6 14 </tbody> % of row total <tbody> A B...

Hi, I have a work book with two sheets. On the Sheet1 I have a table with data for Restaurant in cells A1 to I4 Then I have data for Super market in cells A6 to I9 Finally I have data for Coffee shop in cells A11 to I14 <tbody> A B C D E F G H I 1 Restaurant Discount offer...

Hi Hope someone can assist, looking for a calculation to give a precise value. I have this table <colgroup><col style="mso-width-source:userset;mso-width-alt:2779; width:57pt" width="76" span="2"> <col style="mso-width-source:userset;mso-width-alt:4534;width:93pt" width="124"> <col...

Ive been lurking on these boards since I started working and a former boss of mine steered me to the site. you don't know it but many of you have been incredibly helpful over the last 6+ years, so thank you. boss of mine decided to start a new monthly excel challenge and while I have one way of...

I'm currently making a form in excel which can dynamically change picture placements based on user input. So far I've done everything without needing to use any VBA. My current issue is that when I zoom out the pictures become misaligned and don't always realign when I zoom back in so I'm...

Hi, I am trying to find a quick way to calculate the cumulative value and percentage for multiple sets of data and below is an example of the data I have and the last 2 columns is what I am trying to calculate. <tbody> Store Category Article Sales Units Cum Sales Cum % A Necklaces 5424170...

hi all.. not a mathleet by any means.. I sold 1 of product A last year, i sold 2 this year.. % increase; (This year - last year) / last year = 100% increase I sold 5 of product A last year, i sold 0 this year using the same formula = -100% (shouldn't it reflect -500%)? thanks

I'm trying to rank some stats. The problem is that I don't want to encourage blind use of a particular work related function, and so I only want to count up to 100%, anything over 100% should be considered as 100%. However I also need to display the actual results still, so I cant just edit...

I have a drop down list in columns B7, B8 and B9. Its a simple Yes or No selection I would like if B7 - Yes then cell G7 = 100% If B7 = No, then cell G7 = 0% :confused: Thanks!

Hi, I'm trying to get a return in (H5) based on Column E multiplying by Column Q (100%, 130%, 150%). When I type the formulas individually they work, as IF(AND(E5>=O5,E5<p5,g5*q5) and="" so="" on="" for="" each="" of="" the="" other="" two="" returns.="" however,="" when="" i="" try="" to=""...

This has been bugging me for some time now. How do you calculate a exponentially increasing Weekly Goal %, over a 52 week year, that sums to 100% at the end of the year. I don't have a particular starting point... just know the sum of the 52 week percentages has to equal 100%. This % is used...

Hi there I'm having a small issue with my email hyperlink in that what I have works correctly, only when there is no "&" symbol in the cell that the link is referring to. If there is an "&" symbol in the middle of the string, the hyperlink only extracts the part prior to this. Is there perhaps a...

Hi, Is there anyone who can help me figure out the probability of each number on the different A-B-C so that it will be like the answer to the right. Preferably with VBA. <colgroup><col span="5"><col span="3"><col><col><col span="3"></colgroup><tbody> Match % % % Probability % A...

I have a test value - call it AB - that I want to find in a table in a different sheet then find the corresponding value 2 or 3 rows over. Here is an example: Tab 1 <tbody> AA Meaningless text random number AB Meaningless Text random number AC Meaningless text random number...

I am working on extracting some information from an existing spreadsheet and copying the information to another sheet based on search. In column named Welder I want to extract that rows information for each individual welder initial and create a different workbook for each one. What would be...

Hi, I am trying to multiply the values in column H with the value's (100% +values in column I) and divide by 100%. Basically (H*(100%+I)/100%). I have the below code however its giving me type Mismatch error. can you please help Dim LastRow As Long Dim X As Double, Y As Double Dim cl As...

I'm trying to track usage over several years, for a Santa's Grotto operation. There are several types of present and what I want is one bar graph, with three 100% stacked columns, showing: Presents used/remaining this time last year. Presents used/remaining (based on the number of bookings)...

Hi, I'd greatly appreciate help finding a formula that will calculate the figures in red (cells C3:F6) in my mockup below. Column I contains sales thresholds at which different bonuses are paid in 4 tiers labelled in Column H. If I sell 100 units in Quarter 1 (Cell B3), that would mean all of...

<tbody> <tbody> A B C D E F G 1 Table 1 Table 2 Amount % of Total Portfolio % of Total Asset Under/ Over % Notes 2 >=20% 100% 15,292 4.70% 1.50% -15.30% I can't understand how this formula works. The value isn't true but still returns(D4-A4). It should return(0) 3 >=20%...