if/and

Hi, I am working with a formula that I am getting some weird results and hopin someone has a solution. I have two Concatenate formulas that combine about 3 Columns of data, These formulas are in Col J:K. I then have two other columns that individually look at each concatenate formula nand...

=IF(AL2="",AND(OR(S2="IN",S2="KY",S2="HI",S2="WV")*TODAY()-N2/365)) Above is the formula I wrote to calculate less than 18 years for particular states. This is what I a trying to achieve and not sure how to go about it. Column AL has ID Column S has States Column N has DOB Column AE has...

<tbody> TABLE 1 Widget --Length of Widget-- --SF of Widget-- $$COST$$ </tbody> <tbody> TABLE 2 --Length of Widget-- $$COST$$ 0-5 Feet $10 6-10 Feet $15 </tbody> I need to create a formula that will calculate the cost in TABLE 1 assuming a minimum for the --SF of Widget--...

Hello, I have two IF/AND statements that need to be combined into the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks. =IF(AND(R19 < g19,l17="hourly"),(g19 2080),(g19="" 26)) =IF(AND(R19 >...

Hello, I have two if/and statements that need to be combined in the same cell. Each statement works separately but I cant seem to figure out a way to combine them. Suggestions welcome. Thanks. =IF(AND(R19<g19,l17="hourly"),(g19 2080),(g19="" 26))...

I need some help with parenthesis for an "if/and" formula. =IF(and(VLOOKUP(D5,'Eligibility'!$C$5:$H$100,6,FALSE)="YES",(T5>=10%)),"Yes", else if (s5>=10% and (VLOOKUP(D5,'Eligibility'!$C$5:$H$100,6,FALSE)="No","Yes")),"No")))))

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be automatically selected. The criteria for selection are: required power and required head (m). I need to extract the right model from a table that compiles...

I am attempting to deliver a pricing model (matrix). The model is dependent on the number of average transactions (x-axis) and the number of overall customer. As pricing increases, the incremental cost decreases (i.e. the incremental cost at 5,000 is less than that at 1,000). I have created...

I have an excel spreadsheet where I need to calculate due dates daily. I have four categories, Overdue, Not Due, No Plan. I have an if statement for this and it works. =IF(ISBLANK(B2),"No Plan",IF(B2<TODAY(),"Overdue","Not due")) My problem is that I also want to split the no plan into 2...

I'm using a nested If/And formula with 13 different logical tests. Basically, I'm trying to get an age value displayed when I enter a date of birth into cell B3. Of the 13 logical tests, I have 3 that span a number of years and then the other 10 are only covering one year. When I input the...

I'm doing a large set of nested IF/AND statements that isn't working correctly. It's supposed to check if both a user ID is the same as one in the cells 10 rows away, and if the sum of 10 cells in a column is equal to 10. If it is, it subtracts some timestamps. If it isn't, it's supposed to...

I have a spreadsheet of physician names, clinic referred to and number referred in columns. I need to transfer that data to another sheet. So I need to search for specific physician at a specific clinic (they work in multiple clinics) and pull the value associated with that to another sheet. The...

I'm pulling my hair out trying to figure this one out. I have a fake mock-up spreadsheet but the forum will not allow me to post attachments. I am trying to do a nested IF/AND formula that will give me the EXACT name in a specific cell on a different worksheet. Example: "If the obligation...

Hello All, Below is a formula I found on the website and I've been trying to modify it and make it work for what I need but to no avail. Here's what I'm trying to do: In column B is a list of last names, however, some of the cells are empty. For those cells that are empty but the row still...