complex formula

  1. J

    Dynamic calculations for capacity

    I am working with an Excel sheet that tracks project efforts across multiple roles (e.g., Senior Designers, Junior Designers) for each month. The goal is to calculate the total effort needed for each role, factoring in the backlog as well, the calculations should assume that the backlog items...
  2. S

    Need help understanding SUBSTITUTE MID SUBSTITUTE REPT formula

    So yeah surprisingly I didn't find any explanations on this semi complicated formula =SUBSTITUTE(MID(SUBSTITUTE("_" & B7&REPT(" ",6),"_",REPT(",",255)),2*255,255),",","") So here I used it to extract a value between "_" characters. But I want to make other additions/operations to this formula...
  3. S

    Create User Defined Function from excel sheet calculation

    Hi, I would like to create a User Defined Function (UDF) from a complex calculation in an excel sheet. Illustrated as in the screeenshot below: - Value D11 is calculated as a sum of D6-D10, which are in turn complex IF functions. - Now I would like to have somthing like...
  4. M

    Presenting a 10% increase with multiple variables

    Hi All - First time post and it's a bit of a doozy! In the linked image, I'm creating a spreadsheet to help me cost up items for an eBay store. I've given 5 examples (including the formula from each cell of row 4) of how the COG (Cost of Goods), Stationary cost, Postage cost, eBay & PayPal fees...
  5. C

    Does anyone know how to sort the results from a formula into ascending order?

    Morning Friends I am after some help with what I think is a complex formula. I have two spreadsheets. One the first is a summary of the information contained on the second sheet and I am trying to create a formula that will lift reference data from the second sheet and put it into ascending...
  6. B

    Ignoring blank cell in complex Sum formula

    Creating a title for this was tricky. So I have a spreadsheet in Google Sheets where I have three sets of data that I need to add together but there are times one or two of the cells might be blank. Basically, I am trying to create a Score for a call center rep where a call is worth 8 points...
  7. R

    Using IF, AND & similar functions to determine cell value based on factors

    Hello everyone, I've been at this for 3 days now, all over forums and google with no luck. Refer to the picture I posted in this post for reference, but I need help calculating the monthly bill amount based on various factors. Basically: If there are no values in a row from columns K through...
  8. S

    Reorder cell contents in reverse order - YIKES!!! quick resolution required!!

    Hi all, Got a sticky situation that is stressing me out, so need expert help!! I need to change the cell contents in reverse order - kind of sorting the cell Z-A but by line. I want to reverse the cell layout so that the latest comment is at the top. ie Comment 5 followed by 4,3,2,1 (the...
  9. D

    Complex formula help

    I have attached a simplified version of my massive spread sheet. Since it is confidential i have changed things but the point is the same. Any help ASAP is very much appreciated. I spent 2 hrs trying to figure this out. Look at the spread sheet Ok so after viewing it if cell B and C are not...
  10. X

    Complex VLookup

    Hi: I need some help with a Vlookup I am trying to create. I have 2 Sheets. Sheet 1 have the following columns: - SKU - Starting Date - Quarter - Price The Price column is the one I need to fill in with a formula. Sheet 2 have the following columns: - SKU - Price - Effective Date The...

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 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.
Go back
Back
Top