equal

I need your help writing an if/then statement in a pivot table - I need to write if c5 is = 1 and d5 is equal to 0, then "closed" otherwise "still open"

I have a dynamic equation that is filling across multiple cells, so until the equation is completely generate, I have not included the "=" sign at the beginning. I thought adding it would be as simple as Cells(i,j).Value = "=" & Cells.Value, but this does not work. I have tried the same thing...

Hello, After much research I haven't been able to find the formula I need. I am looking for a formula that will return a value based on what was entered into A2. I would like to insert a value into A2 then have the formula return a specific value base on a range. The range would be: If A2 is...

Hello! I'm looking for a formula (maybe sumifs?) that will lookup the 'Name' column and 'ID' column and return the sum of the 'Amount' column BUT for only those ID's that are unique. For example, if I lookup Name "ABC" it should return 550 because it'll sum 200 + 350... not both 200's because...

Hi, Match type (-1) returns the largest value that is less then or equal to the lookup value. Is there a way to return the largest value that is only less then the lookup value, and now equal to? Thanks

I'm attempting to sum column P:P with the following criteria" A:A = DS J:J Contains "Board" AA:AA does not equal "Invoiced" My Sumifs formula is working up until the "does not equal" part is added in. I'm not sure where "does not equal" needs to be placed. So below is as far as I can get...

I am having a problem trying to count the values in a column when the value I want to count is greater than or equal to a value in another cell. For example in cell J5 I have the value of 70 and in column G13:G207 I want to count the times the values in column G13:G207 is greater than or equal...

hello All . i have a question i have a table with name po and qty and lot i need result lot how like i post image in image i give fist lot until his lot vale equal or grater then his total then pick next lot until his balance equal and grater then to qty ...

<tbody> <tbody> I'm trying to do the following: I have 3 worksheets A, B and C. In worksheet A, I have dates, names and corresponding values, in the sheet B I have names and the total that each one has, i.e. the following act e.g. = b2 from sheet A gets the data, and in sheet C I want for a...

hello all, I need help with the funtion I am able to do len first and then if function but i cannot get them to work together. I need a function that can take the Length of the numbers in cell B17 and if greater than or equal to 8, display a value of "Cusip" If the length is less than or...

Hello everybody I need to rename and move files from Folder A to Folder B based on some criteria I have 3 column A, B, C Column A : contains "old/parent path" Column B : contain "new name of files" Column C : contains "new path " I need a code of three parts 2 have been solved but at third...

Hi, I am trying to set up a formula which will sum the numbers in one column that meet the following criteria in two other columns: a particular month (in one adjacent column) and greater than or equal to +0.5 (in a second adjacent column). I've put the following formula in but can't get it to...

=SUMPRODUCT((YEAR($D$24:$AN$24)=H2)*($D$25:$AN$36)) trying to adjust above so the full formula is returning the value based on: 1. the year in D24:AN24 being equal to H2; and 2. the criteria in B25:B35 being equal to E3 with the values in the range D25:AN36 help!

I have a chart with a CF as : Equal to " within the CF set up, but I wanted to know if it would be possible to have this " Equal to " to be a cell outside the CF set up but on the chart itself that would represent the whole column ? the reason why is because I would like to see if I can change...

Hello masters !! Ok I've been struggling with this and it might be very simple:laugh: The formula or vba code that im trying to figure out should Search for Agent Name ( A:A ) if the agent had a start time that is equal or larger than G1 but equal or lower than H1 time, then the formula...

I want to modify this formula =(BF70/1000)*$BG$4 So that if the result is equal to or greater than the value I have in BG2, enter that value. If the result is less than value I have in BG2, use the value I have cell BG3. Thank you in advance

Hello, I have reports that are in whole dollars and decimals with subtotals and totals. I need to report these in thousands. The round(x,-3) formula works for presentation for the individual rows and totals, but the sum does not equal the rounded totals and subtotals. I end up having to add...

Let's say I get a datapoint of something that fluctuates over time and I enter it with a date down two columns. I want to find the last date where it was equal to, or less than the current value. And I want to find the first time it was equal to or higher than that value. An example might be...

I'm trying to find a formula that provides a count of the number of times in two columns that the values in corresponding rows are equal. I've tried various versions of COUNTIF without success. I realise this could be done by creating a "shadow" column that flags each row that's equal, then...

I need to show certain percentages if certain numbers come up. The formula can be in A1 and the number can be in B1. Example: If B1 is equal to 2.9 or less put in a 0 if B1 is equal to 3 but less than 3.5 put 10% if B1 is equal to 3.5 but less than 4.0 put 15% if B1 is equal to 4 but less than...