excel if formula

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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)
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. 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

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