Hello I'm new to the forum and look forward to your insights
I have the weight band in column D and want to look up the prices in columns E to J how do I return the right price for each row?
See below
<tbody>
Weight (lbs)
Weight Band
A
B
C
D
E
F
167
A
156.53
126.79
107.98
90.78
78.94...
Hi,
Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked.
Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year.
Below is...
I've tried really hard to find an answer to this problem but cannot find it.
Basically I have an table which is populated as below:
<colgroup><col><col span="5"></colgroup><tbody>
Band 1
Band 2
Band 3
Band 4
Band 5
Product Group A
10
25
40
55
60
Product Group B
15
20
25
35
40
Product...
Hi
I'd like to calculated the average salary for employees based on salary bands.
The table below shows salary bands and the number of employees in each band.
What's the best way of working out the average salary by salary band?
I thought about taking the mid-point of the range then...
Hi all,
I have a list of of employees with a unique number assigned to each one.
Then i have a separate list with the entire list of employees and their 1Up manager as well as their 2 Up manager.
I need a script that will look up that employee on the list, finds their 1 UP manager, checks...
Hi,
I've been working on a formula for this for a while but haven't been able to crack it, any help appreciated.
The data I have is peoples ages, and I want a formula to be able to take the age and automatically assign it to the correct age band.
So I need to combine the following into one...
Hope you can help!!
I have a progressive pricing formula I need help with, been tearing my hair out
Each band gets individual earnings in steps apart from <10 that gets nothing.
In the below example customer sells 35 baskets, so will reach the 4th band.
Band 1 - Zero
Band 2 - 10 * £1.15 =...
Hi there,
I am wondering what the easiest way I can band values which are the closest to the actual values. Take the below example:
Here are my bands:
<colgroup><col><col></colgroup><tbody>
Chargeband
Exc VAT (pence per min)
1
4.5
2
4.5
3
4.5
4
13.5
5
13.5
6
13.5
7
13.5
8
36...
Hi
Slightly weird question and I'm hoping Excel is not going to let me down.
I've prepared an IF statement to show if a hourly rate of pay falls with a band of two pay rates and to return "YES" if it does and "NO" if it doesn't -
=IF(AND(R3>=T3,R3<=U3),"No","Yes")
If I get back "NO" I then...
Hi Board,
I have a form that recalls a product price from a table (tblFurniture), using a dlookup.
As follows:
UnitPrice: DLookUp("[1stBand]","tblFurniture","[ProductNameText]='" & [Element] & "'")
This works fine, but I want to return the price based on the selected band (1st,2nd,3rd etc)...
<tbody>
Question
Col A
Col B
Col C
Col D
1
Angry Birds , Gaming
Android, IOS
L1,L2,L3
2
Nirvana,Rock,Band
Y,Z,A
M1,M2,M3
Please find the question on the top and the expected result at the bottom
There is no limit on the number of comma separated...
Hi forum,
I am working on a employee performance report. Usually the employee task complexity divided to three major categories like Easy, Average and Hard. For every complexity we give banding based on accuracy limits as per below table. Now I need to map this to my main fact table column...
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...
Hello,
Looking for some help / advice please.
I have the below table of data - which i have created into a stacked bar chart to show each band and the equivalent band widths (minimum-maximum). The chart then has a line chart over it to show the average at each band.
<tbody>
Band
Average...
Hi
I have some excel documents that calculate wages for band members depending on certain criteria and band cost. However I want to reverse it so I put in the criteria, enter the band member hourly rate and works out how much the total quote is. It’s difficult trying to explain without showing...
Excel 2012ABCDEFGHIJKLM1Using 2 additional helper rows to set
band2JanFebMarAprMayJunJulAugSepOctNovDec3Inventory71535829307817682714414Lower Band Value6060606060606060606060605Upper Band Value7070707070707070707070706789Without using 2 additional helper...
Hello to all,
In the attached file I must include this formula:
If the cost in E2 is in one of these bands:
Band 1 (less than 400 €)
Band 2 (from 400 € to less than 800 €)
Band 3 (from 800 € to less than 1200 €)
Band 4 (from 1200 € to less than € 1,500)
Band 5 (from 1500 € and beyond)
Put in...
Hi,
How would I vlookup numbers within ranges of numbers?
For example, I have the following ranges of numbers
50000 100000
100001 200000
What I want to do is be able to lookup my number (say 105000) within those two ranges and do so in a formula.
Separately (and I believe this would...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.