complicated formula

Hello, The below sheet calculates the figures based on number of objectives set and how many of these objectives have received 'needs development', 'meets expectations' and 'exceeds expectations' criterion. I need to be able to calculate an overall status in A8, based on the following...

Hi all, I am trying to build a part number generator based on certain characteristics of what's required, and I am not even remotely sure how to achieve this. My excel skills are definitely not this advanced! Any help here would be really appreciated! I will upload pictures I am working on...

Hello, This one has the potential to be quite complicated, as UK holiday law is governed under the Working Time Directive. I have been trying to make a calculator on Excel which calculates holiday entitlement and can also take into account if someone starts employment part-way through the...

Hi everyone,I do have a complicated problem to solve and I was wondering if anyone can point me to the right direction as to how to tackle this problem.So I've got 5 product codes, and I've formulated 5 different unique excel formula codes for each product. For example,Product 1codes to...

I'm not sure if this is even possible, but I have a table with approximately 4K rows, with each row listing a student and the grade that they received in a particular course. <tbody> A B C 1D 1 Student # Name Course Grade 2 12345 Jack ENGL 101 3.3 3 12345 Jack MUSIC 200 3.7 4 12346...

I have been searching high and low for a formula that will meet my needs but cant find one! I appreciate any help or guiding light! I have a spreadsheet set up for my grocery list. Column A contains the name of the product, Column B contains the estimated price of that item, at the very bottom...

I have some shares and i want to do some comparisons. eg. This month vs last month, this week vs last week, this week vs last 6 weeks ect I have been experimenting with the advanced filter but keep bringing my self to confusion. For now what i need is to extract data for each year, month, and...

http://www.box.net/shared/0ebhd83tg6 Hi Guys So heres what I want to do. I need to link up the PO's and part values on the Stock out and relevant values to the corresponding PO's on the Consignment stock sheet. (It makes sense when you look at the workbook) For example Column B on the Stock...

I have a complicatedd problem that I am working on. 1 want to have a cell where I have a number and be able to take that number and Add to it itself + a percentage, however the problem is taht I need to be able to do this multiple times Example. Take 2048 as main number with 10% as...

For my spreadsheet, I am designing a program where the user can enter what they have eaten every day, and it will then give the results at the end of the week. However, my input table looks very cumbersome; it is very long incase the user needs to input a lot of food. What I want to be able to...