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

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

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

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

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

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

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

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

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