nested formulas

I built a PTO calendar dashboard where it automatically updates the employees availability for the day based on the calendar's data. The options vary from U (unscheduled), holiday, jury duty, covering, or a value over 1 is added. This is what it looks like: =IF(OR(VLOOKUP(N28,table...

I'm alittle stuck here trying to figure out how to combine these two formulas 1st Formula is : =TEXTJOIN("",TRUE,IFERROR(MID(Q17,SEQUENCE(20),1)+0,"")) 2nd Formula : =MID(A17,14,4) Would really appreciate the help thanks

What I need, is if AB17=yes, then if X17=In-State, $7.50 but if X17=Out-of-State, $13.50. But if AB17 is blank and/or doesn't =yes, then no response. This is what I have so far: =IF(AND(AB17="yes",X17="In-State"),"$7.50","$13.00")

I wish it was as easy as pasting creative formulas from Excel to VBA, but alas it is not, which is why i am here... I have this formula working in a cell, but would like it to work in VBA: =EOMONTH(EDATE(DATE(YEAR(AA3),FLOOR(MONTH(AA3)-1,3)+1,1),3),-1) The purpose of it is to get a date and...

We have booths for rent and I have put together a sheet that I can list the dealer #, the booth # they occupy, the sales $, and it will calculate the sales per square foot. The booths are classed as different types based on the location of the booth (Type 1=1st floor front, Type 2=1st floor...

I am not getting the results from the formulas as expected. One returns the correct data but still leaves the dreaded #N/A if no match is found. =IF(ISNA(MATCH($A:$A,4-8-16,0)),(VLOOKUP($A:$A,'04-08-16'!$A:B,2,FALSE))) The other returns all 0's...

<tbody> A B C D 1 Day Duration Start Day Duration End Day Total Duration Time 2 1.2 1.5 1 3 1.6 1.8 2 4 2.3 3.4 3 5 5.3 5.8 4 6 5.8 6.1 5 </tbody> I need to calculate the total duration time per day for a large amount of column data in multiple worksheets. The tricky part is...

I'm using Excel 2010 on Windows XP. I would like to vlookup to an excel log that tracks the dates of each time a customer was contacted. The customer may be contacted up to 4 times. I want the vlookup result to be the last time the customer was contacted. Essentially, if E2 is blank I want the...

Hello! and thank you for helping me find a solution to this problem. Right now I have a very long nested function that has around 200 if statements and left functions. The function works great, but I can only go as far as 64. The purpose of this function is to get part of a string in a cell and...

Hello community! I have really been struggling with this formula for a while now, I'll try and describe it as succinctly as possible. I have an externally referenced workbook with many tabs (December 2015, January 2016, and so on...) on it containing Ticker Symbols for stocks in the first...

I have a dropdown that gets its reference indirectly from another cell. The referenced list is a table column that will contain any digit from 1 to 9 but not necessarily all of them and some will appear more than once. I can find lots of way to extract those unique values but This would mean...

I've often wanted to look up if it was possible to concatenate the results of a column of concatenate formulas (of course, CONCAT only starting in Excel 2016) I thought maybe there would be a function like "FUNCTIONTEXT" but "FUNCTIONVALUE" So I started looking and I can't seem to find...

Hi please help. I have the below formula but it has too many nesting levels: =IF(C4="1st",'Step 1 Materiailty Assessment'!B25,IF(C4="2nd",'Step 1 Materiailty Assessment'!B26,IF(C4="3rd",'Step 1 Materiailty Assessment'!B27,IF(C4="4th",'Step 1 Materiailty Assessment'!B28,IF(C4="5th",'Step 1...

Hi All, I am struggling with one formula. I have one sheet - In this sheet(tab1), I have to get "heads" information in Column D with criteria of the following columns - Column A(Region) - Column B(Country) - Column C(Line) when match With the tab2 columns( A to C) I want vlookup to match...

Hi, I have a data sheet with the following columns. Skill Name; Assigned Chats;Transferred Chats; Conference Chats; Total Chats; Average Worked Time; Averaged Wrap Time; Average Handle Time My hope is to sum the product of cells in Column E (Total Chats) * Column F (Average Worked time) when...

Hello all, I searched around on the forum for an answer for this, and I found some solutions that were close. I was not successful at adapting them to my needs (and I feel like this should be easy!). I have a spreadsheet with testing data (quality control tolerances), so there is a column...

Hi, I'm running analysis of data that includes delivery times for two distinct store types (stores under 3000 and over 3000). Each delivery is distinguished by "Run" which can repeat for different regions (see example below). What I need to find is relative position of stores that are over 3000...

Hi folks, how are you doing! I'm facing a challenge trying to find out and conditional formatting a vertical cell range against a horizontal cell range, both with dates. At least, that is what I think to be my challenge, :laugh::laugh:! In the link below a model and instructions: OneDrive...