understanding

Hello Everyone, I want to take the input of the line number from the user . I want to run the operation from the cell range (A1:T100) (example) Taken input from the user (1000) concated to T1000 ( Cell = "T" & Uinput ) and used it in the Range("A1:Cell").Select But getting error. Please see...

Hello Everyone, I want to take the input of the line number from the user . I want to run the operation from the cell range (A1:T100) (example) Taken input from the user (1000) concated to T1000 (Cell = "T" & Uinput) and used it in the Range("A1:Cell").Select But getting error. Please see...

=(NETWORKDAYS($AF2,$AG2,Lookup_table!$J$2:$J$10)-1)*("19:00"-"7:00")+IF(NETWORKDAYS($AG2,$AG2,Lookup_table!$J$2:$J$10),MEDIAN(MOD($AG2,1),"19:00","7:00"),"19:00")-MEDIAN(NETWORKDAYS($AF2,$AF2,Lookup_table!$J$2:$J$10)*MOD($AF2,1),"19:00","7:00") can anyone pls explain and understand me how this...

Could some explain to me in plain english how the second part of this vba code equates to the following formula in excel please? .Range("I" & .Range("I" & .Rows.Count).End(xlUp).Row).Formula = "=IF(R[0]C[-4]=""*Activities"",0,RC[-1]*0.1)" equals I7=IF(E7="*Activities",0,[Price ex. GST]*0.1)

Hey, I just wanted to take a moment to give a big shout out to everyone here on the forum. I really appreciate your time and assistance throughout the 1+ years that I have been on the forum. The amount of support and quick responses, not to mention clear and concise responses, has been so...

Hello I need help understanding how the formula is calculating the end result. =SUMPRODUCT(J$21:J$97,$H$21:$H$97,--($B$21:$B$97<>1),--($C$21:$C$97=$C104))/$H104 The first part is summing column J 5,429,225.00 The second part is summing column H 482.71 The third part I believe is counting...

Guys, I'm stumped! I've been working on this issue since yesterday but lack the understanding to get around it. My issue is with this formula in particular: =MIN(IF([@[max dim]]<=priceSchedule[Max Dim], IF([@[median dim]]<=priceSchedule[Med Dim], IF([@[min dim]]<=priceSchedule[Min Dim]...

Hi Guys hope all is well i have the below table at work with data and forumla, and i need help understanding 1) what the formula are doing 2) if i can improve these formula ( is there a more efficient way to do this. <tbody> A B C D E F G H I J K 1 NAME START DATE END DATE TOTAL LENGTH...

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")

In "Excel VBA Power Programming 2016" Chapter 7 there is a function to determine where the format of a cell is Bold Function ISBOLD(cell) As Boolean ' Returns TRUE if cell is bold ISBOLD = cell.Range("A1").Font.Bold End Function It works when used in a spreadsheet and "cell" is an...

Hi, I have this formula where the sheet name is La Source and I need to incorporate an Indirect function into it for it to be dynamic. I've tried videos to get a better understanding but have not succeeded. =IF(AND(Schedule!D5='La Source'!C6,Schedule!E5="Salon...

Hi all, I need some help with confidence in the following code. I have a data set which is given to me in the wrong order. So I need to sort the data in ascending order, by the content of column B. The data starts from row 8 Each row contains a set of measured values from an automated test of...

Hi to all Good Afternoon I got genetic distance matrix based snp genotyping data of 10 individuals in matrix format and now I want convert it into data frame format like genotype1 in columnA and genotype 2 in column B and distance between them in column C and also rank them genotype wise for...

Hi Sorry if that is off topic. I want to know the difference between these 3. I google it but no one seems can explain it in easy and understanding way. Thank you.

I need logic understanding on this.. I have this value in my column.. also While using this formula, I'm getting answer like this.. =IF(A2="MR",HOUR(A2),"") also Why I'm getting 11 on a1 and a2...where I getting correct on a3 and a4..

Note: I tried to search but I am so naive that I don't even know what to search for. Snippet: https://i.imgur.com/mqaFGRp.png Two Parts 1. I want to be able to type "Dustin Johnson" (B2) in another cell (let's say 'Z1' for example) and have the value in the final column (B13) appear in 'Z2'...

I wrote this formula a long time ago and it seems to work, but I am having trouble understanding what I did.. Can someone help me figure out what is going on here? VIPs (C2:C6) =IF(IFERROR((-2.5*$B2)+(1.5*$A2),"")<=0,"",IFERROR((-2.5*$B2)+(1.5*$A2),"")) How many VIPs do I need to have the...

Hello. I want to get some help on understanding a formula. The reason is that I want to use it for my job. I have created a spreadsheet to help with what I am having a tough time with. This is the formula that I am using...

I'm trying to rid my file of all VOLATILE functions; the only one remaining is a single NOW() function, however there are a few hundred cells who depend on that Now() value, so my understanding is that even though only on cell is technically 'volatile', I've effectively turned it into several...