equation

Hello - I have seen a ton of posts on this topic but have yet to find a solution that actually works. I plotted time series data on a graph and the trend line equation is showing as "y=1E+08x+1E+09" Therefore I tried to get the actual value of the trend line by using this equation against my...

Hello, Coming to you guys looking for a little help. I attached the spreadsheet for reference. The cell I'm working on is F11. It has an equation in it that I need to link to two drop down selection. About 3/4 of the way through the function is "0.75" That is a fixed value I put, that I...

Hello everyone! Tab 1 called "Component Matrix" I have a list of all my components vertically in Column C --> C5:C11 I have a list of all my programs in column F4:J4 See below for what I mean - This table represents a usage matrix. Program 2 has 1 of each of the following components - 1...

Having trouble writing an IF, AND, AND, OR Equation. Wishing to based on what the dollar amount in column D and the desired choice for a percentage, I believe I came close but no cigar. Spreadsheet is available. The AND should be if cell D is greater than zero, then do X, Y, Z, based on the...

Hello, I need to keep track of my colleagues daily/monthly progress and need to sum from multiple tabs (31 tabs) and multiple columns. Every tab is for a day of the month and im try to add Jon Does data from every tab, using Index Match to do this, but if just one of the MATCHs doesn't find a...

Can anyone help me sort out a problem with an array formula? I get the following pop-up error message when I hit the Ctrl-Shift-Enter keys: "The formula is missing an opening or closing parenthesis." The array equation is as follows: =IFERROR(INDEX($C$3:$C$200...

Hello all! I am once again posting for some support. I have developed a spread sheet that reports back information to the "master sheet" from other sheets in the workbook. In my scenario I am trying to improve a function where three contacts need to be made before the file can be escalated...

Hello all I am new to using the more advanced functions and equations within excel. Could someone help out with a SUM equation to always include max value of column A as a part of the equation and then add this number to the SUM of the two highest max values from either column B or C or D...

Hi All I am trying to set up an "if()" equation where I did like to controle the number to insert based on a cell with or without "x" I have got to the following equation, but it does not work. =if(AN16="x",BE16=AH16,BE16=Z16) So the idea is of course that if AN16 has the value x then...

'=IF(AH1=AL1,OR,AH1=AM1,OR,AH1=AN1,"YES", " ") So I'm trying to find a YES if any nunbers in AL1 or AM1 or AN1 match the number in cell AH1. The numbers found in AL1,AM1 and AN1 will always be different. I've researched "OR" but have found only examples that do not include "find any that...

i recently came across a table having formulas like this =IF([@SENTDATE]="","(Undated)",YEAR([@SENTDATE])) Which i cant seem to figure out what are the @SENTDATE variables in the equation. there are columns with those names however i tried to reproduce the equation on another sheet with...

So this may be dumb but I type in January and then auto fill down and get to December. I think use that as a month ref in an equation =month(a1) where January is typed and I get an error. What do I need to do so that I can type a month and have excel know that when I use the month function?

Hi I need a bit of help with a nested IF AND formula. I can get nested IF's to work with no problem, however if I add and into the mix it seems to go awry. The data i have is as follows; <tbody> A B 1 2500 Yes 2 2500 No 3 1200 Yes 4 1200 No 5 1900 Yes 6 1900 No </tbody> The...

Is it possible for Excel to determine the monthly percentage for a 5 year sales plan where the only input would be the annual sales goal for each of the 5 years?

I am looking for some advice on how to do a Sigma calculation in Excel. I have quite an elaborate equation that calculates rebate percentages on casino bets. I'm able to calculate the equation for one round of betting, but when it gets to more than two rounds of betting the equation gets bigger...

Hey all I have never needed to vlookup based on dates to return a result until now and i keep getting a #N/A result. So what i want to do is lookup the item by date and return the result of the item The equation im using is: =vlookup(D1,A2:C4,1,false) Cell D1 would have a date i wanted to...

I just need a very simple explanation. On this worksheet, I'm only presented with graphs and I have to come up with the two equation by myself. How would you solve for the equation?