multiple conditions

Hi There, I was wondering how I would go about making condition variables to use in IF statements. The end result of the code is to calculate the total number of hours that a project has been worked on based on a starting time and date and ending time and date. However, there are two breaks and...

Good evening all, So what I am trying to accomplish is summing data from one sheet (DATA for example), on a second sheet (SUMS for example) if specific conditions are met on the data sheet. I also want to make sure I am summing the data for only the matching number on the SUMS sheet. There...

Hi, I am trying to write a formula that picks up a value within a set of data with two criterias, one is in a row and the other in a column - is this possible? This is the table where I want to create the formulas. I am trying to pick up the value with the date and the type (eg. SIG). <tbody>...

Hi everyone I wonder if excel can do this. I have a conditions want to make like Like if any of this cells A2,B2,C2,D2 and E2 has a value of "0" (zero) then F2 will put zero otherwise F2 will become 1.. Sorry I am new for this I am learning some basic functions.. THanks in advance....

Thank you in advance for your assistance. I need to perform two related functions on a set of data. Here is a sample of the spreadsheet, which is actually around 500 lines long and will be growing in the future: <tbody> ID Case 1 Case 2 Case 3 Aa23 none (24) none (31) none (14) Bb34 7...

I am looking to increment Column A by one, if the corresponding cell in Column B has text. It gets tricky as shown in the picture attached / linked at row 9 and 10. B9 and B10 have no text, so A9 and A10 are not incremented. The next column with text is B11, so that value in A11 is 9. I...

Dear folks, Much appreciate your help with below case: Restrict cell A1 with 2 conditions: - A1 must be alphanumeric - Length must be < 19 I try OR(AND(CODE(A1)>=65,CODE(A1)<=90),AND(CODE(A1)>=97,CODE(A1)<=122),AND(CODE(A1)>=48,CODE(A1)<=57)) with the first condition but it seems like it only...

Hello All, I have what I think may be a "simple" IF statement function, but I'm having trouble ensuring the "variable" can be randomaly assigned" to a category (depending on the results of the IF statement). So if you take a look below I'll try to explain. I have a set of survey...

I have multiple conditions for Or and And that need to be in an If statement. How do I write the IF statement? Thanks in advance! Conditions: <tbody> If A or B is no, then no If A or B is maybe, then maybe If A or B is NA, then take the other cell Else, Yes <tbody> A B Should...

Hi there I'm wanting to return a value based on a reference IF another value in a row is between a certain date range. For example, out of all of company X's products, I want to look at the listings that were released between 1/2/13 and 1/4/13 and return the product code if those conditions...

Hi, I am stuck trying to use a sumproduct with three conditions. My objective is to count the number of dates for a specific geographical region which fall within a certian range. 'Launch Tracker'!$H$3:$H$1200 = the column reference where the region is contained e.g. Europe The date range...

Hi all - I need to use "countif" functions for rows with certain values that work in multiples of 5. It's a bit complicated but I need to figure out a macro or short script I can run that counts occurences just for a select number of rows. i.e. A B C...

Hi all, I'm fairly well versed in functions and array formulas and am surprised that I'm just running into the issue below for the first time. I want to average the data in 'column b' only if the qualifiers 'x' and 'y' are met in 'column a'. For example Column A Column B Red...

Help!! I have a rather complex (to me) scenario which I just cannot work out the best way to deal with this... any suggestions or samples would be really appreciated!! I have a workbook with two worksheets, Sheet1 and Sheet 2. Based on the data entered in the 2nd column on Sheet1, I'd like a...

I have scenerio in excel Job Nature, in Column T which have values (W), (F) (M) Days to check in Column S which have values "No. of Days" & Paid W/Card in Column N which have values True , False The Thing I want to check is, if Job Nature is (W) and No. of Days is <= 365 and the W/Card is Ture...

Hello, I trying to figure out a formula in Worksheet 1 that will compare the holdings in Worksheet 2 to the restrictions in Worksheet 3. I've included a table below, but please note the following: The restrictions are identified by the sedol. The XYZ Weight in Worksheet 2 indicates the...

Hi All, I've been trying for a little while now through research and I'm finally stumped. My excel needs have usually always been solved through searching, learning and then modifying what I've found, not this time. :confused: Let's say that I have 3 columns. Column A is called range1 and...

Hi Everybody. Was wondering if anyone knew how to do the following (apologies if my excel jargon is off, I'm not what you'd call a pro!) OK so my situation is this. I'm working with a database that holds information on individuals backgrounds. At the moment I'm looking at education history...

Hi, I am manually calculating the undermentioned data and am tearing my hair out. I am sure there must be a better way of doing it. Please help.... I have to calculate the time taken for two parts of a task which has three/four steps. The steps are differentiated by specific words i.e...

Can someone help me put together a formula for the following situation. A1: =5 B1: = 32 C1: = If a1>3 and b1>30 = "X" C1: = if a1<3 and b1>30 = "Y" C1: = if a1>=0 and b1<30 = "Z" What would that formula look like in the C1 cell? Thanks