excel if formula

  1. S

    excel if isnumber formula with wildcard

    Hi all, I am trying to look in cell E863 and see if the word deferred appears. I tried the formula below and I even added a wildcard before the D "*Def*", but for some reason sometimes excel was not seeing the word. Sample in column E off Deferred Aug20 =ISNUMBER(SEARCH("Def*",""&$E863&""))...
  2. M

    Complicated IF statement returning false

    I am using this long IF statement to calculate the commission rate for sales people. The value if true portion works but the value if false returns FALSE in the cell instead of executing the false instruction which in this case is (IF(R11<1,(H11*($C$7/10000)),H11*R11). Maybe I cannot have...
  3. S

    IF function on Time

    Hi can I please ask for help is it possible to use IF to Time? If its between 08:00 - 15:59 CST time it will be AMER If its between 16:00 - 23:59 CST Time APAC If its between 00:00 - 07:59 CST Time EMEA I tried...
  4. S

    IF with OR and Today Functionality

    Hi, Is it possible to associate =today() to if this is an example: the current tab i'd like for it to change from EMEA to AMER if today the work time is 10 PM onwards and be change to EMEA if the shift was changed to 5PM, is that possible can i kindly ask for help please thank you Absent AB...
  5. M

    How to prevent a cell from calculating formula until all data is entered

    I am trying to do something that I imagine isn't that hard, but I'm not an excel super user, just a novice with google. I took over a spreadsheet that tracks our generators run time. It is simply just subtracting the time on the run meter for the current month, from the prior month. Example...
  6. D

    Multiple IF/VLOOKUP String (Excel Example Attached)

    All, I want to thank you in advance for helping me. I just need help creating a custom IF/VLOOKUP string based off of a list table. I will attach the file for an example. It should be pretty straightforward. Once I get past 3 or so IFs combined it starts getting choppy for me. I really do...
  7. J

    excel If and Formula

    I want a formula that If J1 is less than 1000 and H1>0 and I1>0 then the value should be 1000-J1 else 0. I am trying this formula but getting error. =IF(J1<1000,(AND(H1>0,I1>0)),(1000-J1),0)
  8. H

    If columns 2-4 have data, but columns 5-7 dont. Then call True

    Here is where I am going with this. But where am I going wrong? all type(2). Formula in Col8 -I'm getting tied up while trying to ensure the first 2 characters in column2 is a number "0-9" SO heres an example: <tbody> Col2 Col3 Col4 Col5 Col6 Col7 Col8 Jon Doe 123 Main St Acity, MN 55304...
  9. H

    If formula with time

    Not too good working with time in excel. But what I would like to do is write a formula in an adjacent cell: If the time is; 06:00-10:00 = AM1 10:00-12:00 = AM2 12:00-14:00 = MID1 14:00-16:00 = MID 2 16:00-18:00 = PM1 18:00-22:00 = PM2
  10. J

    Insert rows in excel based on specific Conditions VBA macro

    I have a excel sheet where there are many Balance rows. In Column A there are Demand Collection Balance Rows, where Balance = Demand - Collection. So there are multiple Balance Rows are there in that sheet. Column FGHIJ are inter related. I want a macro that if in any Balance row there are...
  11. M

    HELP - easy q for those well versed in excel

    So, my situation is as such: I'm sure I need to use the IF formula, however not quite certain whether to use and/or. This is what I want to do: IF the value of say A1 is less than B1 but greater than C1 then the answer should be the data I've input in say D1. I have 6 References, say A1:A6...
  12. M

    If Formula Nesting Level Error

    I am trying to use the following formula in Excel 2007, but I keep getting the following error message: "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format" Can anyone help? This is the formula I am trying to use...
  13. T

    Easy excel formula

    Afternoon all one of those days to day , i have the following formula =IF(ISERROR((SUM(F2-E2))),"",(SUM(F2-E2))) and need to add into it also return "" if the number is less than 1 but unsure where to place it, sure it will take someone here 2 seconds thanks for your help , Tim

Some videos you may like

This Week's Hot Topics