if statements

  1. A

    VLOOKUP, IF statements, and contains functions?

    I am trying to do something, but I am not sure if excel can do it. In column C:C, I have a list of over 100,000 hyperlinks. These hyperlinks are very long and have a lot characters in them. These hyperlinks sometimes contains a project number. In range F2:F100, I have a list of project numbers...
  2. E

    Nested IF Statement multiple condtions

    Hi can anyone help with this one I working on a stats sheet and I have people with 2 different scores and a table for reference that gives them the ranking value. I'm not sure nested if are the way to go so any suggestions are welcome A1 A2 A3 A4 Agent Name Score 1 Score 2 Rating...
  3. S

    Open If statement

    Hi, I need to be able to say if a specific day is between two others. More specifically if I tell you my store is open from Monday-Friday I want to be able to check if Sunday is between them. If it is, I consider Sunday open. This should returned "closed", but Monday-Friday should return open...
  4. 6

    Excel Formulas in Access

    So I know that Excel supports basic programming statements like the ever useful IF statement. I was just wondering if anyone knows if it is possible to use these types of statements in Access? I am aware that access does support Iff statements, but not IF in the query sections of access.
  5. P

    Today function in a If statement

    Hi everyone, Im trying to create a tracker that displays the current grade of my class to the main dashboard along with the progression number which is determined from the predicted grade to the current grade. say they were predicted an A and the current grade was a B the progress would be -1...
  6. T

    Using Concatenate and If statements togehter

    I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty. Is this possible? I need to stream line some worksheet process building reports for management. I only have one stumbling block left regarding the following formula...
  7. S

    Excel Solver help

    Hello, So I've been trying to tackle this issue for way too long by now. My last resort is asking here for help: It's an optimization problem i need to solve with Excel Solver. I'm encountering my problems when i want to use IF statements but they don't work with solver and I don't know in...
  8. T

    Using If statement to pull data from adjacent cell in a range of cells then copying to another seet

    Hello, I am working with a report where i need to sort through associates names/different job positions/titles in a table in columns 2&3 THEN copy column twos values and add it to its designated spot(next empty row) based on that associates job title. the vba that i have pieced together does...
  9. S

    if Sumproducts

    Hi, I have a data sheet with the following columns. Skill Name; Assigned Chats;Transferred Chats; Conference Chats; Total Chats; Average Worked Time; Averaged Wrap Time; Average Handle Time My hope is to sum the product of cells in Column E (Total Chats) * Column F (Average Worked time) when...
  10. M

    Percentile with IF statement

    I have a spreadsheet where I am calculating average GPA by month over the course of three years. The data is pulling from a table I have on another spreadsheet. I want to find the 25th percentile for each month. The formula i'm trying to use is...
  11. H

    You have entered too many arguments for this function

    Hi I am trying to check if the cell [@channel] condition is met before doing a index and match function...
  12. L

    Help with IF function with Matching

    I need to make a formula that will check to see if a client's name is part of a range of data and then return the value "Township" if they match. If they don't the value should return a blank. To do this I've used an IF statement and took the cells I was checking against and converted them into...
  13. tycasey17

    Nested IF Not Reading Correctly

    I have a nested IF Statement that if a single cell has one at of information. For example: =IF(A1="YES", IF(AND(B2="OLD",B3="DOG"),"OLD DOG",""), IF(A1="NO", IF(AND(B2="YOUNG","CAT"),"YOUNG CAT",""),)) The formula isn't that simple but it gives the basic premise of what my issue is. My issue...
  14. mikekoda

    Nested If statements

    Can someone help me please. I want to know how I can make an if then statement for employee pay. I have seven different levels of pay. B, C, D, etc. Under each level of pay are different rates. If level B compensated employees make less than 75 units then they should be paid $8 per unit. But...
  15. tycasey17

    Using Defined Names in a IF Statement

    A1 = PVT =IF(A1=_OFF,"Yes","No") The Defined Name of "_OFF" list officer ranks and PVT would not be one of them so the result should be NO. However, this formula doesn't work it returns a #VALUE! error. I was trying to avoid using a VLOOKUP statement for this to keep my formula a little...
  16. C

    Vlookup and If statements

    Hi All, I will try and explain my problem and hope you can help. I need to identify data on one table using a vlookup, if that data contains certain text (ABC) i need it to then get the cell to display data from another cell within the same table. Below are fragments of the data set Main...
  17. A

    Problem with Nested IFs Using Find

    <tbody> The following is sample data: The first column is the original data: The second column is what I am getting when I use the formula in the third column. The fourth column is what I would like to get. I thought I understood nested iFs, but I am missing something. Thanks! 719 S ABERDEEN ST...
  18. M

    Too Many If Statements....

    Hi, I was hoping that someone could help me out on an if statement that I cannot seem to get to return the correct number. It seems right? I need to calculate a set %age of sales based on the sales number if =<400,000 then return 10% if>400,000 but less than 450,000 then return 12% of sales if...
  19. F

    Simple IF Statement Help!

    Hi All, this is probably really basic but I'm completely new to IF statements and I haven't managed to find anything online that explains this simple task which I'm trying to do... Basically I have a bunch of dates in a column in a spreadsheet - let's say they're in column A. Column B is blank...
  20. S

    Too many variables for nesting "IF" function

    I have a rather large spreadsheet that gives me the following information: 10112 Biloxi MT Manager Trainee BOP Active 2 CSR Customer Service Rep BOP Active 2 MGR Manager BOP Active 1 10112 Biloxi BOP Active 5 This...

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