bands

Hello Please could someone advise how best to create the following pay bands in excel: <colgroup><col></colgroup><tbody> £0-7,550 £7,551-9,925 £9,926-12,500 £12,500-17,500 £17,501-22,500 £22,501-30,000 £30,001-50,000 £50,001-100,000 £100,001- My data is 4500 lines with pay...

Hi, I want to allocate some limit values into Limit Bands based on certain conditions. I have two tables in PowerPivot and I am trying using DAX functions to do it. The two tables are the following, 1. A table with Attachment Limit values (Named "Exposure") with the following fields...

Hi, I want to allocate some limit values into Limit Bands based on certain conditions. I have two tables in powerpivot and I am trying using DAX functions to do it. The two tables are the following, 1. A table with limit values (Named "Exposure") with the following fields, <tbody> ID...

I have to calculate fees based on different bands, for example ( first 2000, next 3000, next 5000 etc) see image below, I need help to resolve this . See file at the link below https://drive.google.com/open?id=1lwt6O8v32yC1WcH7VGQ4_R6qoBeAT2ix Please help Regards

Hi All, I have values in column L such as the following: 400,000 300,300 1,230,340 I want to group these into certain bands within Column M, the band are listed within a separate tab called "Bands" and the options are as follows - how can I code this? I fear the word "Euro" could cause...

Hi there; I have a small problem, I need to condense this table of formulas into one calculation and this is beyond my meagre skills, I build the table to calculate some discount bands, basically applying a rate to the cell highlighted (red) taking the figure apart portioning it into bands and...

I have a list of date of birth in col A and in Col B I need to allocate to them a band based on the table below (bands in bold); <tbody> 01/09/1997 31/08/1998 N 01/09/1998 31/08/1999 M 01/09/1999 31/08/2000 L 01/09/2000 31/08/2001 K 01/09/2001 31/08/2002 J 01/09/2002...

First... sorry about my english... I try to explain better as possible... I try to make this table in power pivot Forecast Band / Skus Quantity / Sales / Forecast 0-49.99% / 17 / 500 / 1,500 50%-79.99% / 12 / 1,000/ 1,800 80%-100% / 5...

Hello, I have a weird one for you guys today..very interesting if you ask me! As an example, i am trying to work out the cost of 78 parcels, where from 0 - 25 parcels we charge $8.95 per parcel (Up to 25 parcels (8.95*25) = $223.75), 26 to 50 parcels (8.45*25) = $211.25 and 51 - 100 (7.95*28)...