equation

Hi everyone, In B3, I have the equation: =AVERAGE(INDIRECT("b"&(today()-$A2+5)):INDIRECT("b"&(today()-$A3+5))) When I drag this equation horizontally the two ["b"}'s stay as b's. What can I do to have the two ["b"}'s change to the new column with everything else in the equation staying...

I have this equation {=INDEX(F7:AS7,1,MATCH(MAX(IF(F6:AS6>0,F6:AS6)),F6:AS6,0))} row 7 is a bunch of names what i want returned row 6 is maybe some numbers and maybe 0 and could all be 0 if all of row 6 is 0, i want the equation to return nothing. Now if they all go to 0, it retuns the last...

i am trying to use the product equation to product some values from certain date rang, i was thinking maybe there is some-sort of productif equation or so. thanks in advance

How do I write an equation in excel that has the following format: IF "C3 is found anywhere in Column H" then IF "D4 is equal to either Column I or J (on the same row as where C3 was found in Column H)" then "Pass", Else "Fail" this will be continued for the rows, e.g. search for C4 anywhere...

What do I need to do to this equation, so I don't get the #DIV/0! result? =IF(E43<=(N43/2),((A25/(ROUNDDOWN((N43/E43),0)))*B43),A25*B43) Same with #VALUE ! =IFERROR((D25/(ROUNDDOWN((O43/H43),0))),"")*B43 Thanks

Hi guys, Im having some difficulty formatting a 2 digit financial year. I currently have a column for the installation date --> which contains either just a month, or a specific date and a column for financial year --> this contains this equation: =IFS([@[Inst''n...

So here is what I am looking to do I have a column of dates then a calculated number 1 2 or 3 I have test data and results, I want to calculate the total for the year with an equation but I need the test date to be the latest one so here, 2/10/18 uses 3 then 6/2/18 uses 8 Equation is like this...

Hi, I have an equation below that should return a 1 if true (which is working) and a 0 otherwise for any other values (which is working partially). So for some items it is returning 0 but for others it is returning a FALSE which should be a 0 if the equation was working correctly...

Hi folks, Need your help. I'm trying to find an equation to insert into cells E2:G5 that will look for the number of occurrences of the number “1” in a row, and then output the column header. I’ve been googling, and it seems this would require an equation using a combination of index, match...

Hi guys, I've been using this forum for long time, but this is my first time posting ;). Recently I got math problem to solve on job interview, which I did on paper, but problem is it was needed to be done in excel. Below is question and the way I did it on paper. Please help me solve it through...

Hi I am trying to display trend equation on my line chart but the option is grayed out in the format trend window. Why is that? Thank you so much.

I am using a Vlookup equation that works perfect in 3 cells (it is looking up a date associated with a name. it is looking up a date in column 5, 6 and 7. but when i try to use THE EXACT SAME VLOOKUP EQUATION to bring back something else, it just fails. it just shows the equation, equals sign...

Hey all, Sort of a novice to excel here... I'm having a huge amount of difficulty getting excel to understand what I'd like. Essentially, I want to take data I input into three separate columns and have it inputted into an equation. The equation is 0.5(4/3*(pi*a*b*c)). Four-thirds multiplied...

I realize this is probably something small that I am overlooking, but currently I have a way to get a total of a certain month and I need to change it to a certain year. Is it possible to change something in this equation so it pulls everything for the year instead of just the month...

Hi all, I am looking to get a return of a name from column J if column L contains the value "C". I've set up an index function that works fine if column L contains ONLY "C"...but the problem is sometimes column L contains text like "C, RW". I need to tweak the equation I have to return if...

Hello, I got stuck with my computation. I will try to explain the problem but it is rather complicated to do so. The first task is to compare values for each cell in two columns in Sheet2 with another values in Sheet1. (e.g. if sh2.A1=sh1.B:B and sh2.C1=sh1.F:F then...) If those match, in...

Can I use excel 2016 to calculate Kellys equation K% = W – [(1 – W) / R] W = 0.34 and R = 0.86 If so how do I do this? Please forgive me but I am a wiz at math or excel :confused:

I have a dataset with a variety of values. One of them is an integer T that also happens to be in column T. I have an equation that will switch between two options based on the value of T. It's easy to do with an if statement, but I want to build it into this equation so that it can easily be...

I want to identify my inventory level (days) based on actual/forecasted pull-out and not the average. The desired result can be achieved thru this formula: =IF(F9>J9,1,F9/J9)+IF((F9-J9)>O9,1,(F9-J9)/O9)… But it would be a very long equation if I apply it to day 1 to 31. Can anyone help me...

Greetings all, I have a project that has three values (an index, a wavelength and a time) in the cells: S43, U43 and W43 respectively. Once those values are entered, those values are matched in a list and an equation is returned from a fourth column. To match those values into the list I have...