# ifs

1. ### Problem using nested IFs

Hello everybody, I seem to have once again attempted to write a formula that was beyond my current skill level, and I need some assistance. In the Cells B9,B11,B13,B15,and B17 I have this formula(well the cell refs are different): =IF(B22>0,B22,"-") In B19 I am trying to get an average...
2. ### Extracting consecutive letters from a cell and applying the IF function

Hello everyone, First timer here. I'm working on an email database and am looking to sort them into type. I am trying (without success) to use the IF function as follows. If A1 contains the letters "isd" consecutively, then B1=TRUE If A1 contains the letters "google", "yahoo", "hotmail", or...
3. ### Need help immediately with school project for a mid level computer class

working on a basketball spreadsheet and have a few questions I have made a simple basketball spreadsheet that calculates FG% 3pt% pretty basic stuff, but i have run into some problems and the teacher doesn't really know whats going on i hope i can get some help and fast. My first problem was...
4. ### mulitple IFs

i have a spreadsheet that does a vlookup if cell A7 has text in it which i want to display as a hyperlink the formula below works great but i dont want it to display anything if the vlookup does not contain any text so i have been trying to insert another IF in the vlookup but cant get it to...
5. ### nested sumproducts and ifs

Hopefully someone will be able to help me out with this! I looked through the threads but wasn't finding exactly what I was looking for. I am creating a spreadsheet to track different employee leaves using some conditional formatting but am having trouble with the totals at the end. The...
6. ### Conditional Minimums

Hey everyone, I am trying to set up a conditional Minimum formula. On Sheet 1, I have 1000 IDs split into 20 different groups all on one rolling list. So Column A has all of the IDs, Coulmn B has the group name they are in, and Column C has the values of each. On another sheet (Sheet 2) I have...
7. ### Mulitple OR's using IF's?

I have a problem that is driving me crazy. I have data coming to a cell, it will be between 0.00% and 0.50% I want to have a weighted percentage using this data. So if Cell E39 is 0.00% I want E40 to read 0% but if it E39 is 0.01% to 0.10% I want it to read (-10%) 0.011% to 0.20% reads...
8. ### nested if

my IF statement would be sound like this. IF range("J2:J500") = "ATP" reference cells in same row part#, serial#, date, time. then find where the above "ATP" cells part#, serial# match the same part#, serial# but this time range("J2:J5000") = "FTP 1" then i want to subtrace the "FTP 1"...
9. ### Deduct 15 minutes if cell equals

Hi All, I am currently working on an adherence project & am a little stuck on a formula for the following Column B holds codes ie, Break Column E holds in duration in that code The formula needs to check column B to check its Break, then if duration is over 00:15:00 to count anything over...
10. ### Using And/Or in IF statements

Can you use And/Or easily in VBA I.E. Could you say if(And(A1 = 10,B1 =10),or(C1=5,C2=6,C3=7)) So A1 and B1 have to be true, and either of the "C" ranges could be true, for the whole thing to be true? Cheers
11. ### Complicated contract pricing vba formula

Dim contractmonth As Variant Dim px1 As Variant Dim px2 As Variant Dim i As Variant Range("firstpay").Value = contractmonth Range("firstpay").Offset(0, 1).Value = px1 Range("firstpay").Offset(0, 1).Activate For i = 0 To WorksheetFunction.CountA(Range("froncontract", _...

=IF(Rules!\$C\$19="Positive",VLOOKUP(B116,'data as reported'!\$A\$1:\$HO\$20001,MATCH(\$C\$6&\$C\$5,'data as reported'!\$A\$1:\$HO\$1,FALSE),FALSE)/1000000),IF(Rules!\$C\$19="Negative", -VLOOKUP(B116,'data as reported'!\$A\$1:\$HO\$20001,MATCH(\$C\$6&\$C\$5,'data as reported'!\$A\$1:\$HO\$1,FALSE),FALSE)/1000000),0)) For...
13. ### Combining Countifs with 3 or more criteria

Hi there I wish to combine the following COUNTIFS together but am becoming stuck and stuckier.. as I cant seem to get past the first 2 COUNTIFS Essentially (C2:C47,"Y") is the most important Column C 1st must be a Y to continue with COUNTIFS which are meant to be adding the number of times...
14. ### Min IFs

Probably best to start with the Maxif to show you where i am. {=MAX(IF(Data.!A:A=SRLlist!A358,Data.!Z:Z))}. basically, there is list of 'names' (SRLlist!A358 in this case) that match names on another sheet (data! sheet, column A) for which there are multiple entries. This formula gives me the...
15. ### circular reference problem!

This is a little confusing but I'll try my best to explain my problem. In column E I have a list of strings, and I want to first determine if the string 00-EI is in this column. If this is true I want to then look at the next 2 columns (c and d) and determine if corresponding cells(ie. c3 &...
16. ### Multiple Conditions

I have a grading worksheet, that I'm trying to roll up into a cumulative grade. Example: cell E8 = grading date (default is "Pending", they are supposed to enter grade) cell AU8 = counta formula to confirm all of the grading columns have been populated, "7" means all columns have been populated...

Hi, I am having a problem with writing the ifs and ors. My spreadsheet is basically the first sheet with different positions within a company and beside their names are three columns of rates. <TABLE style="WIDTH: 240pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=320 border=0...
18. ### IF with multiple formula/variable

I'm trying to use IF with other variable but is not working. What I have: Colum G12 - NET Sallary Colum I12 - 3 possibilities (MRM, ME, AB) Colum J12 where I will have my formula. I have another table with 3 datas: MRM = 1,709 (P3) ME = 1,544 (P4) AB = 1,630 (P5) What I need to do is...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...