if and formulas

I always have trouble with nested IF AND formulas. Trying to figure out how to combine the two formulas below based on whether a number falls between these two sets of numbers: <tbody> A B 1 11 13 2 23 25 </tbody> =IF(AND(N$3>=$A$1,N$3<=$B$1),"PY last 3","") and...

<tbody> Questions 2016 Favorability Standard Deviation 2017 Favorability Standard Deviation 2018 Favorability Standard Deviation Result Q1 66.5% 1.15...

Hi I'm trying to create a formula to deliver three different outputs based on conditions of three columns. Conditions: IF a2 = 11 AND d2 = 028 return NI Landline OR IF a2 = 11 AND c2 = 07 return Mobile OR IF a2 <>11 return Other Number It;s necessary to check Col C...

Hello I have a list of suppliers and sales reps that are assigned by Alphabet. For example; any supplier that begins with letters A-C are assigned to JAMIE, in addition to that any suppliers that begin with letters D-F are assigned to DONNA and suppliers that begin with letters G-I are...

Hi I'm trying to write an IF statement that will tell me if 3 consecutive zero's appear in the row of another worksheet. I also need the statement to tell me if there are more than 3 as well.

hello : I would ask you how can i write code vba for following: I would to count within range(g3:g1000) which contain certain date and count range(p3:p1000) which contain the "4130" and put the results in cells in another sheets I wrot this but don't work: if range("g3:g1000")=date and...

Hello, I am wondering if anyone can help me. I currently have a Conditional Formatting set up to highlight a cell if it is a duplicate. Is it possible to highlight a cell if it's duplicate and another cell contains specific text. In my spreadsheet, there is a name in column D that I want...

The two IF(AND statements I currently am using are the opposite of each other to compare column C to F and then F to C: =IF(AND(C3="NOT FOUND",F3<>"NOT FOUND"),"CHECK","OK") =IF(AND(F3="NOT FOUND",C3<>"NOT FOUND"),"CHECK","OK") Is there any way of combining the two (maybe with an OR statement?)...

I may be wrong, but I'm thinking I need to write an if function to accomplish my goal but can't seem to figure it out on my own. I have 13 columns and 26 rows. Rows list names of staff and columns list the months of the year. For each staff name listed on each row, when "yes" is entered into...

Hi, I need to set up conditional formatting with 2 conditions. 1. If E14=Completed AND C14>=D11 THEN Color Cell Green 2. If E14 Does not =Completed AND C14<=D11 THEN Color Cell Red Note - Cell E14 has validated values in a pull down menu. Cell D11 and C14 are both dates. I've been working...

I am trying to write an IF condition, first criteria is Column D, If Column D Value is 3, then Result value should be 99006661001 If Column D Value is 9, then Result Value should be 52006881570 If Column D Value is 6 or 5, then second criteria is based on Column C (First 2 digits), If first two...

I already have used a formula to notify me that a job is $20K or more by using =IF(T20>20000,"X", " ") and obviously in T20 is the project amount. I use this becuase I have to track the time for a job $20K or larger Now, in F20, the cell directly to the left of this formula is the state which...