and condition

Greetings, im trying to achieve a single function where the following happens: =IF(M3<30, "30 Days or less","" =IF(M3>=31<=60, "30 to 60 days" =IF(M3>=61<=90, "60 to 90 days" So essentially, I'm looking at a bunch of resources where i want to see when their contract is due and separate it...

Hi guys I was wondering if there was a way to do a Vlookup with an IF, AND, perhaps even an ISBLANK statement and what that formula would look like for the following scenario. I am trying to create a worksheet that will allow me to type in a restaurant ID and it tell me if It is closed on...

Hello I wrote a formula in order to trace the boundaries of some wind values. The boundaries are 0-90 / 91-180 / 181-270 / 271-360, and in return I want to get 0 for the first group, 1,2,3 for the second,third and fourth respectively. The formula is the next one...

Hello. I am trying to get a count of the cells that contain certain texts in one column (K) AND have a cell value greater than 2.5% (.025) in a different column (O) This is the formula I am using now: =SUM(AND(COUNTIFS(K:K,{"GROWTH1","GROWTH2","GROWTH3","GROWTH4"}),O:O>0.025)) I am getting a...

Hi all, I have a multiple IFs condition formula which works fine below: =IF(AND(I200="",J200="",K200=""),"N",IF(AND(G200<today(),h200<>"Complete"),"Forecast End Date is before current date - Status needs to be Complete or Date needs to be updated. Note: Status also cannot be...

I am trying to populate a unique count of the following conditions Column B is either a Cake or Cupcake Column C is not equal to No Column D is not equal to No Column E is not equal to Yes If all the above is true, I want my cell to display a count of people who satisfy all the above. So...

I have a vast amount of data, and I want to return a specific cell's text value if certain criteria in other columns are met. I can use SUMIFS to get it to work for values (numbers) but cannot apply a similar theory for text. Probably easier explained by much simplified example below... I feel...

Currently I am working with my data collection on my master thesis and I am trying to figure out which formula to use in order to gather together the information from two different sheets on Excel. For example Sheet 1: I have stock with the code nr of "8135" and daily stock return for this...

My formula is returning a 0 when true instead of being blank as specified. If I designate a value other than "blank" (i.e. "A Word") it still returns a 0. What am I doing wrong? =IF(AND(CBAuditType="PHYSICAL",TxtInsuredName=""),"",TxtInsuredName) If you need more information to help let me...

Hi Guys I have a formula that I am having issues with, there is a an example file here https://app.box.com/s/08cucpffqosyiswsi15c The formula is =SUMIFS($D$4:$D$99983,$A$4:$A$99983,AND("=$I5","<$I5"+1),$D$4:$D$99983,J$4) I think the AND part is rubbish. I5 in this cell = 1 Col D will be 1...

Hello, I am trying to use this formula: =IF(AND(C753>=10/01/2012,C753<=12/31/2012),"Qtr 1",AND(C753>=01/01/2013,C753<=3/31/2013),"Qtr 2",AND(C753>=04/01/2013,C753<=06/30/2013),"Qtr 3",AND(C753>=07/01/2013,C753<=09/30/2013),"Qtr 4","N/A") I know that the "AND"s are screwing everything up, but...

Hello - I have the following SUMIFS formula that I am trying to incorporate an AND statement. My current formula is: =SUMIFS(B27:B1000,X27:X1000,"Active",X27:X1000,"Transfer") I am trying to add an AND statment into this formula which would say AND IF AR ≠ blank, do not include the value...

I have a worksheet that is used to log phone calls. We can get several calls from the same person and I would like to identify the dup call. I am doing this with this statement: =IF(COUNTIF(C$2:C$1000,C2)>1,"DUP","") This works well to identify the duplicate callers. My challenge is that...

Without going into too much detail of the process, the tool I am designing allows the supervisors of a net repair shop calculate how long each panel will take to complete, and what time the net will be completed at. To calculate the time, the supervisor enters in information on each panel, and...