if function

  1. U

    Vlookup alternative or if function

    I have data in multiple excel sheets in the same workbook. All sheets have the same table but different data as each sheet represents a certain date. The name of shops in the table are chosen from a dropdown list and you can see the full list of shops to the right of the photo. What i want to do...
  2. K

    Can someone please help me with the nesting of IF/AND functions?

    What I need, is if AB17=yes, then if X17=In-State, $7.50 but if X17=Out-of-State, $13.50. But if AB17 is blank and/or doesn't =yes, then no response. This is what I have so far: =IF(AND(AB17="yes",X17="In-State"),"$7.50","$13.00")
  3. R

    IF / AND with exceptions

    Hi All - Looking for help with a problem. I have an IF function with an AND inside it, the AND has multiple rules. Currently, the formula works great but I am looking for one of the AND rules to allow for an exception based on words in a separate cell. Current Formula...
  4. T

    Transposing a Column into A Row Alphabetically Based on Criterion

    Hello community, I have a challenge that I am currently unable to overcome: In one worksheet, I have two columns; one entitled 'TYPE' and one entitled 'PRODUCT CODE'. Under TYPE, you will either have the word 'ALPHA', 'BETA' or 'OMEGA'. Under PRODUCT CODE, you could have one of a huge...
  5. S

    Extracting a number from a text string and returning a third value

    Hello All! I have one Excel file In Column B (275 rows) I have a number (all of these numbers are unique) In Column C (275 rows) I have a string of text which contains several numbers within the string (all of the text strings are unique) In Column D (275 rows) I have a different number from...
  6. B

    IF function giving error... do i need to add AND function as well?!

    Good Morning All, Having issues with my IF function formula, and i'm sure its user error. For the life of me, can't figure out what issue is and how to resolve. Any help would be greatly appreciated. On my sheet, i'm trying to compare orig dates (Column A) vs actual dates (Column B); easy...
  7. B

    IF Formula - nested

    Hi, I need to create an IF formula based the following information (my goal is to have a column with hourly rate per employee, whether they are hourly or salary so I can do a vacation accrual - see details below): col BC this column says either SALARY of HOURLY on each line (by employee) col...
  8. W

    If Formula to calculate cell with value

    I am trying to create a formula that will create a result for a cell if a range of three cells has a value: IN K6-------> IF D6 contains value multiply G6 by 15 IF E6 contains value multiply G6 by 15 IF F6 contains value multiply G6 by 10 Each row (6-xxxx) will have a value in ONLY one cell...
  9. Y

    If Function to Copy a different cell value into another cell and change different cell value

    Hello, My first post because I usually find my answers without asking :) So here's my issue: I'm trying to create a formula, using IF Function maybe??, that copies certain cells from one sheet to different cells in another sheet and change a cell value on the first sheet, but the cells are...
  10. 1

    Loop through code and then run if statement

    Hi, I am trying to loop through all cells in the range J10:J25. When a cell is smaller than the value in cell "D12", I want it to change color to red. This is probably simple, but I am unsure how I can target each cell to check for the if function. ActiveCell does not seem to work. I could...
  11. S

    IF function

    I need a little help with what I thought would be a prettysimple if function; however, the solution seems to allude me. I have 3 columns. Column H is going to generate text (“Yes”or “No”) based on what’s in columns I and J. Columns I and J are for dates someone is certified in aparticular...
  12. B

    IF function

    I have 25 information cells, in a separate cell it will tell me which box to get my information from. I want a formula in another box to show the information from that cell. If cell A says 10, I want cell B to show the information in cell 10; if it says 25 in cell A then I want box B to show...
  13. P

    Summarizing date table to monthly closing

    I have a table with four columns (ID, Date Taken, Date Return, Amount). The Date Taken & Date Return column only closed yearly. <tbody> ID Name Date taken Date returned X1 XX 16/11/2017 31/12/2017 X2 YY 1/1/2018 15/5/2018 </tbody> From that table, I need to derive number of days for...
  14. H

    I don't understand why my formula won't work?

    Hi! If anyone could help with this, that would be very very helpful! I am trying to identify in Cell U2, people who either missed a class many times in once month, or consecutively missed classes in the following months. So I would like Cell U2 to say "TRUE" if either S1 or T1 say "TRUE". I...
  15. T

    Using Multiple IF Functions in same expression

    Hello, I am trying to change the values in my Status column to either Overdue, On Track, or Blank. These will reference my Due Date column. I have figured out how to have my cell = Overdue or On Track, but am having difficulty adding an additional layer to the formula. Currently, I have...
  16. G

    Excel for counting, sum, sort by models and maxim limit

    Hi, I'm facing a challenge and I am sure that there is a way to deal with some help because there are smart people around...;) I have different products per day, and I must organise to store them like that: each box can store max 60 products, every model in one box (if there is a different...
  17. L

    IF and TIME, hopefully an easy one

    Hi All, Hoping this is easy for all you experts out there. Im trying to do an IF statement based on a difference in time, I have entered =TEXT(Late time-Early time),"h") so that the time difference is displyed in hours only, hours and minutes is preferable but I can see no way of doing that...
  18. J

    IF Formula

    Is there a way to create an IF formula holding the false value constant until the IF formula is false? Then after the IF formula is false, remove the constant cell reference? This may sound confusing so I will explain further. I am currently showing a retirement plan graph showing...
  19. E

    VBA BeforeCLose

    Hi all, I have the below code and this is what I want to achieve: IF L1=1 AND B1="" AND C1="" then I want to prevent the file from saving. In all the other scenarios, the file should be saved. I need to also be able to specific Sheet name. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As...
  20. T

    Nested IF: return "High" if cell value is >5, "Low" if <-5, and "Mid" if in between

    I've tried so many options but it only seems to return one answer. E.g. The values I have are [A1] 41, [A2] 0.08, [A3] -2 and [A4] -13. In B1 I have: =IF(A1>5,"High",IF(A1<-5,"Low","Mid")) This returns "High", which is correct. But I drag it down into B2, B3, B4 and the cell ref A1 changes to...

Some videos you may like

This Week's Hot Topics

Top