20%

Hello Guys ! Is there any formula to do automate this calculation ? <tbody> A B C D 1 10% Discount 3 ( Insert Formula ) 30 2 20% Discount 10 30 3 15% Discount 50 333 4 VIP 7% 10 143 5 Weekend 25% 25 100 6 Weekend 25% 25 100 7 Weekend 25% 25 100 8 15% Discount 10 67...

Hello. I searched the forum for VBA code to auto-send emails in outlook, and came up with the following, which I adjusted a little. But would appreciate adjustments to fit my requirements if anyone can help. Any adjustments I tried resulted in errors or incorrect results. Changes I would...

Hi I cannot post any attachments so I cannot share the sample data I made. I copied it below. The formatting is off. Hopefully you can still understand the sample. I have a job matrix that shows staff movement. The table is read as follows. There were 22 people from job B that moved...

Hi everyone Hoping someone can help... I have 2 tables on different sheets like so: Sheet 1 <tbody> A B C D E F G 1 Jan Feb Mar Apr May Jun 2 Apples 10% Off 25% Off 20% Off 20% Off 10% Off 20% Off 3 Oranges 20% Off 25% Off 10% Off 20% Off 10% Off 20% Off 4 Bananas 25% Off 20% Off...

Hi Everyone, I'm trying to find a way to pull data values from one sheet and enter them into a table on another sheet. For example, on May 1st 2018 100% of a job is completed: <colgroup><col><col></colgroup><tbody> 01-May-18 100% 27-Apr-18 98.75% 26-Apr-18 93% 10-Apr-18 83%...

Hi everyone. My name is Mathieu and its my first post here so if I make mistakes, please tell me and i'll correct them asap. After searching with no success on the forum or internet I'm seeking your help on a very basic matter (as it seems to me). In one of my % cells is the formula ...

I'd like to do a three color conditional format on one column IF another column has a certain value in that row. For example, if the country is USA and the sales conversion target is 20%, I want to have a rule that makes a three-color spectrum based on the actual conversion rate compared to...

Hi, I have two sets of table, one with few rows and its corresponding percentages (This table varies time to time i.e. number of rows, percentage etc), The other table has fixed 11 rows with percentage values. Illustration below: Table1 (Dynamic) 500,000 - 10% 1,000,000 - 15% 2,000,000 -...

I'll try to keep it simple: I have people doing work for me. Clients pay them directly and then they pay me a fee. They pay 20% on the first 10 clients 10% on clients 11-20 Then 5% on any over 20 How do I get excel to calculate this for me. I obviously need to calculate how many clients...

Hi All, I'm trying to display a data series as a heatmap, but one which changes the size of the boxes depending on the size of the data. E.g. Apples 25% Pears 10% Oranges 20% Bananas 20% Grapes 25% So the above data, if each one was supposed to be 20%, then Apples/Grapes would be Yellow (as...

Hi I am in the UK and analysing data for VAT purposes and want to produce a report with all transactions which show the VAT % of more than 21% less than 19% but not 0%. The data I will have is as below Column A (name) Column B (VAT %) Dave 21% Bill...

Hi, I currently have the formula below looking a set of data comprised of people and percentages. The formula currently looks at if a person is in the bottom 20% and are below the target (0.815). From this it produces either a 3 if they are both below target and in the bottom 20% or a 0 if...

I have posted a similar thread earlier but the formaula I am looking for is now different. I'm looking to create a formula that calculates sales commission from monthly sales achieved. Cell A1 will contain monthly sales achieved. The commission structure is $0-$14,999 - 10% 15k-18k - 20%...

Hi, I'm trying to create an interactive databook. I'm needing to represent the percentage ranges below with the grid number associated with them - and then to have the combination of the two numbers that represent a point on the grid with a corresponding colour. The objective of the databook is...

Hi, I’ve been struggling to put a formula in to Excel. For instance in Cell L4 I want to say the below. Cell L4 = -26% so I want the cell to say Poor. Cell L5 = 15% so I want it to say OK etc. Any help greatly appreciated. If the accuracy is between 0% and 5% or between 0% and -5% then...

I've created a spreadsheet which monitors the daily weights of animals and added conditional formatting so if the cell drops below 20% of their body weight it turns red I have the following formula where it calculates 20% of body weight of an animal =D4%80 that was easy but I'm having...

Hi every one, Ive been glued to this forum for seval hours now, reading older posts, but Im going to admit defeat before my brain explodes!! OK so Im a novice with excel, but I dont want to be beaten! Also before answering, can you help me by just keeping it simple, and basing it on 100-20%...