explain

Dear All, Can any one pls explain me how this formula works.. *Lookup_table sheet = J2 - J10 = holiday list *AF = start date *AG = close date Pls explain..

I found the right formula I need on a site (that didn't explain it :crash:). Between this and other examples, I can't piece enough together to wrap my head around it. Two hours of googling and I'm done! This gives me the first Monday (obviously you probably already know that) and I'm wanting...

Call .FillAcrossSheets(Employees.HeaderRowRange, xlFillWithContents) Kindly explain if its possible? otherwise Please conclude. Thank you

Hello Everyone, I have been working on a spreadsheet created by someone else, however I cannot figure below formula. Can anyone help explain it? Thank you. =XIRR(INDIRECT("R"&MATCH(B4,A:A,0)&":R"&MATCH(K4,A:A,0)),INDIRECT("A"&MATCH(B4,A:A,0)&":A"&MATCH(K4,A:A,0)))

Im posting this video to better explain what Im looking for, for a CF formula, I hope someone can help me with it ? Thank you. Serge. https://youtu.be/joJU_nQyNNI

i am having some doubt so i cant explain , so i want to attach file so anyone can please help me out

Hi I have a formula that i'm struggling to figure out, wonder if anyone could help me explain it? The fprmula is; =IF(N20<5,$J$20*L20,J20*L20) N20 refers to the count of claims paid J20 refers to the Average claim amount L20 refers to the number of claims pending Hope this enough info to...

Hi all. I have inherited a spreadsheet with the following formula in it, can anyone please explain what it is doing. =4/3*PI()*C210^3 Many thanks in advance

Evening all something simple - maybe someone can explain why the the below errors out Sheets(Array("Sheet2", "Sheet3", "Sheet4")).Range("A1").CurrentRegion.Clear

I didn't know how to title this but this is what I am looking for. If I have a list of numbers like below and I want to know when I reach 171, what formula would I use. I the perfect world it would let me know where the row is split. I just don't know any other way to explain it. Any help...

Hi, I am using the code supplied below. At present i have the range as A3:A100 In future i dont want to start fault finding why it doesnt work when my entries go over A100 so how can i edit the code so it will overcome this. I could put A1000 but this is an example of me trying to explain as...

Hey Peeps, This one is a bit hard to explain for me and that's why the title is a bit weird. I hope someone can help me out on this as this will ease up things. I would like to have the following: If A1 = B2 and A2 = B42 So as you can see the pattern is of every 40 cells. Is there a formula...

=IF(D4="",0,IF(D5="",TODAY()-D4,D5-D4,IF(G4="C",D4-D3,))) For the above formula I am getting the Error: You've entered to many arguments for this function. Please help and explain what I am doing wrong? If I just put the first two if statements they work fine. It's when I enter the third if...

Morning, I have a list in the form of a table. I noticed that say the first 12 cells are blue white blue white etc etc but then after that all the other cells are white. Can you explain why this is & what should i need to do if anything. Thanks

Hi Guys can anyone explain to me what this formula is doing? the formula...

I'm working on a file that has the following code, can anybody explain what it does please? =if(coutifs(c:\Storage\[file]\tab1'!$a$3:$a$2600,$a44,c:\Storage\[file]tab1'!$y$3:$y$2689,"*"&mid(n$27,5,100)&"*")>0,"yes","no")

I want to say If Cell 11 is >14 and <26, then return a 0% in cell P11 It seems so easy, but either my googling has fallen to crap or .... I am dumb. Please help me, I will buy coffee.

My formula is =concatenate(A15,B15,C15) which I enter directly by typing "A15" "B15" etc. I would like to create a concatenate that picks up the row number from another cell. Is this possible? This is clumsy but it is the only way I can conjure how to explain: Desired =concatenate(A(go get the...

Hi, I have a column(assume A) with various numerical values from 0000 to 9000 (not in any incremental sequence). There is another column which has many ranges, like 1794-6317 in it (the lower and upper values will be valid and will be in the list). Is there any way to display the numbers...

I saved a chart as a template in Excel 2010, however when I try to utilize it I receive the error message: "therm.crtx:file format is not valid". Can you explain to me why that might be? Thanks!