10%

Hi all, I'm looking for a formula for two things. The first is that I want to return a random yes or no for any record, based on a certain percentage of yes's. So for a 100 records, with that yes variable at 10%, I'd like to get exactly 10 times yes and 90 times no. Then, for the 10% yes's...

I have cash flows in a table for a variety of contracts but initial investment values are separate and the investment dates are also separate, I have tried OFFSET etc but am struggling to make any sense of it. Example: B14..Z14 has the initial investment dates B15..Z15 has the initial...

Hi, I'm looking to apply some simple conditions to return a typical Red, Amber & Green (RAG) analysis. The 3 conditions are set out below the table. The problem one is the Amber condition as it has two metrics and this is the one that I struggled to incorporate into a Conditional Formatting...

I have my sheet set to "Show a zero in cells that have zero value". I am trying to format a cell so that it displays % in a cell when numbers are entered, such as, 0%, 5%, 10%, 20%, or 50%. I used the formula ##\% in the custom cell format, which works for all numbers except for when a zero is...

Hi guys, I am working in Design view of a query. I have two tables below. I want to add a formula in query formula window to help calculate the new grade based on the 10% improvement. In Excel I could do it via Match formula, how can I do this in Access? Table A: Grade...

Hi All, After learning that Goal Seek is limited I started to better understand the Solver Tool. Can someone help me with the constraints to achieve my goal? This is my data (paste into A1) <colgroup><col span="2"><col><col span="2"><col><col><col><col><col span="6"></colgroup><tbody>...

Here's what I want to work out for my holiday rentals: Let's say (for a certain week) $540 is theprice... ALTHOUGH - I want this to look like a 10% discounted price (for example $600 - 10% = $540) Then I have to divide the $540 by 7 to get the discounted daily price. Get my drift? But how...

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...

Hi, I have one table with project costs (many different elements with names and net costs) and second table with margin fee (i.e. 10%). How can I combine to add another column to the first table and calculate margin using value from second table (10%). Till now I used to add temporary column...

So I am after some help with the table bellow, I'm trying to calculate how much time is lost per day due to incidents happening. The table on the top is the information we are given which includes start/finish times, duration and how much impact it had to business. What I am trying to make is a...

I am a swim coach and am trying to create a document where my athletes ca input their best times (mins:secs:hundredths) and it will add a percentage to show them goal times to achieve in practice. For example: Swimmers time is one minute (1:00.00). They input their time and a formula will...

I can't seem to get this to work. <=5% = 1 >5% - 10% = 2 11%=3 12%>4 =IF(AND(D3<0.05),1,IF(AND(D3>0.05),2,IF(AND(D>=0.11),3,IF(AND(D3>0.12),4)))) =IF(AND(D3<0.05),1,IF(AND(D3>=0.05),2,IF(AND(D<=0.10),2,IF(AND(D3=0.11),3,IF(AND(D3>=0.12),4)))))

<tbody> 2018 2019 2020 2021 2020 300 1200 500 100 23000 </tbody> Hello All I'm want to add a interactive button onto my Dashboard: I have a range of costs in columns from 2018 - 2028 example above with costs for each and some without costs, I'm looking to complete a macro...

Hi, I wonder if anyone can help me with the following: A 150000.00 B 100000.00 total 250000.00 If 10% of A needs to be moved from B to A, meaning the total value of A would increase and the total amount of B would decrease but 10% of the new Value of A plus the new value of B combined still...

to try to keep it simple this is the equation I am working with (A+B)/(A+B+C+D+E)=% I am working this toward a goal % as the answer EX (A+B)(A+B+C+D+E)=15% Goal is 10% How many more "E" will I need to get to Goal any help would be greatly appreciated

Hello All, I have spread sheet with the data till 2000 rows, with 4 columns of data. The headers are like "App Name", "Ram Usage", "Category" & "Total Space allotted" Column "App Name" will contain names of Different apps might be repeating. Column "Ram Usage" contains the values of how much...

I'm having trouble adding a column to my pivot table that indicates what % of sub-items are not blank. For example: I would like to get the value in D2 (10%). It's calculated by taking 1-90% (C3). This value indicates that "Sample Item" sold with another item 10% of the time. Data...

I'm having a small problem getting a workable solution created for the below. My data - In column A, I have range of percentage values, accumulating to 100%. Each row can have a value of anything from 0.01% up to 100%. - In Column B, next to the percentage value, I have a text value which is...

I've been trying to solve a breakeven analysis but I get stuck when I want to add a yearly growth on top of the product mix, Does anyone have a solution for below scenario, In total 5 products over a 6 year period, if possible I would like to calculate backwards, so accumulated Net profit year...

Hi Need tutoring or tips to help me calculate increasing an amount by 3.1% CPI and 10% GST over 3 years. For the first year I have a starting amount of rent at 7300 which is required to be increased by 10% GST. I have calculated this to be 8030 - 7300*(1+0.10). No CPI is included in this first...