ifs

  1. andrewb90

    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. S

    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. W

    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. K

    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. T

    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. S

    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. J

    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. L

    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. D

    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. R

    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. H

    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", _...
  12. S

    simple multiple If's not working..please help

    =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. R

    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. J

    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. J

    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. C

    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...
  17. P

    Ifs and Ors Please help

    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. M

    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...

Some videos you may like

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...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top