complicated formula

  1. Chris_010101

    Annual appraisal score 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...
  2. K

    Looking to find the correct formulas / Open to Ideas

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

    UK Pro-Rata Holiday Calculator

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

    Is it possible to insert unique formulas into cells based on a product code?

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

    Help using complex lookup to populate table

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

    Is there a formula for that??

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

    Isolating dates for comparison

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

    IF Formula (Or maybe something else...) 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...
  9. M

    Complicated Formula Question

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

    Complicated Excel Formula

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

We've detected that you are using an adblocker.

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
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 "".
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.
Go back