statements

Good morning All, I am struggling a bit with the indirect formula where I am trying to reference a named range in a different work sheet. The formula is retrning #ref and the formula is: INDEX(INDIRECT("Statements & Variance Model.xlsm!"&"Source_Data"),ROW()-5,COLUMN()) The named range is...

I have the following two IF statements and want to combine them into one. Both work. There are in different columns. Tried but sadly failing. Any help would be welcome. IF(B1="A",IF(H1< j1,"w",if(h1>J1,"L",IF(H1=J1,"D"))),"") IF(B1="H",IF(H1>J1,"W",IF(H1< j1,"l",if(h1=j1,"d"))),"")

Hey guys, (first time poster!) I'm trying to write a nested IF statements, and I'm not sure if there is an AND or OR statement that should be added to complete the formula. My goal for example: IF D27=x,D28=y, return C9 OR IF D27=x,D28=z, return C10, and so on replacing D27 and D28 with...

I'm trying to design a formula for a commission spreadsheet and can't figure this out. The way it works is that if the salesperson sells up to $60k he gets 15%. If he sells $60k to $65k, he gets 17%. If he sells $65k to $70k he gets 18%. And so on; there are 12 commission levels. What I need...

This does not work is there something different to make these statements true? As you can see "J9" should be answer "B" not "A"

Hi all, What’s the best way to test each row in a large dataset tosee if it meets three criteria? If cell A2 is “Blue” and the Expiration Date in B2 is 5/17/18, and C2 is a number, I need cell D2 to multiply the number in C2 by .3 per the table below. And so on and so on for each row. What’s...

I Have the below VBA code but i cant get it to loop every time, until "rFound" is noting, also how do i change "Const FlName" so that it would save in the same file directoy as the xlsm file but everytimes it loops i want the txt file it creates to change its name in consecutive order e.g. chunk...

I have a table with several broad headings at the top. Each of those headings have 3 sub headings. Is there a formula to access each column as all I can think of are a few if statements? (I don't know a lot about excel)

Hi, I am not even sure how to search this. I can find COUNTIF statements but they re only good to tell me how many days fall between before the 20th. Sorry if this is a dimwit question! Thanks in advance!!! :)

I need to nest a few IF statements into a VLOOKUP and I am having issue figuring out how to get this right. I have looked through a number of related post but haven't found one describing my situation. This is my current formula =IFERROR(VLOOKUP(A7,ElliotsPricingUpdate,6,0),"") The table...

I have a formula that is partially working. There are multiple IF statements nested, and the first two actually perform correctly. Once I get into a couple of layers it starts to result in #NAME?. When I click on the various statements within Excel it seems to work through the logic correct...

Hi, I have a question that i'm hoping someone has a solution for. Suppose an investor owns 3 companies: Company A Company B Company C. Each of these 3 companies have various financial deliverables in .pdf form (i.e. Financial Statements, IRR Reports, Investor Reports, ect...) that use a...

broad question but i have a report that ends up being close to 26KB and it takes way to long to open and function. most of the report is based off SUMIF statements, stuff like that any resources, tips anyone has i can use/check to try and make more efficient and shrink the size so the user can...

=IF(AND(C1<>"B",B1<0),50,40) =IF(AND(C1="B",B1<0),40,50) Urgently need guide on how to combine above two IF statements into one.

Hi Guys, I have a question about a merging two IF statements together using the result of the first statement in the second statement. I dont know if this is possible, but here it is.... In long-hand this is what i need Cell M15 to equal: =IF(M21>N21, then M21, else N21, (and here is what i...

Hi there. I was wondering if someone can help with this Microsoft Query issue. I have a staff that's set up and can connect to the server and to the reports and when we try to run a report on his computer he gets the below message. My computer has no problem running the report. Does anyone have...

I have two lookup if statements that work perfectly in two different cells. One checks the value if the calculation is < Add_med_limit and the 2nd >=Add_med_limit. When I try to combine them in one statement either gives error statement or #value . I tried to combine by adding , after first...

Hello, I have two IF/AND statements that need to be combined into the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks. =IF(AND(R19 < g19,l17="hourly"),(g19 2080),(g19="" 26)) =IF(AND(R19 >...

Hello, I have two if/and statements that need to be combined in the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks. =IF(AND(R19<g19,l17="hourly"),(g19 2080),(g19="" 26))...

I have an 'array' that has been convoluted into a single column. Each of the original rows is now in repeating blocks of 7 vertically contiguous cells. I can manually convert therm with a series of Transpose statements derived from a recorded macro. I got the "Unable to set the FormulaArray...