if formula problems

  1. K

    Vlookup affecting an IF formula - multiple If Formula

    Hi I am using the following formula in IA7 to work out total hours between the end of one shift and the start of another: =IF(ISBLANK(HW7),"",IF(IB7="","",MOD(IB7-HX7,1))) This was working fine until I entered a Vlookup formula into HW7 which now enters 00.00 into the cell and therefore...
  2. P

    Conditional sum?

    I have a question about a conditional sum/if formula. Here is my table: <TABLE style="WIDTH: 464pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=618 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt...
  3. P

    simple If formula with buttons

    I am trying to use a simple if formula to look at the true or false column that is produced when the user checks or unchecks a button. The formula doesn't seem to recognize the words. Any ideas? Here is the formula I am using, E3 contains a button that links to G3 and produces either checked...
  4. P

    IF formula assistance

    hi, I hope someone might be able to help me formulate a simple bonus payment spreadsheet! I am trying to fathom "less than greater than" syntax in a formula without much success...! In simple terms I am trying to find a formula that says: In n27 i need a formula "if n26 (total revenue)...
  5. B

    Using an OR in an IF Function

    I'll try to phrase my question as clearly as I can so that you wonderful people can help me! ;) I have Column A and Column B with Data, Column C is where I want to do the Formula and Column D is where I have the labels. Column D is where we label a certain piece of business as registered...
  6. M

    multiple IF functions, expert excel users please help

    how do I have multiple if functions all in one cell? i.e:- =if(and(this cell equals this and this cell equals this display = "","") =if(and(this cell equals this and this cell equals this display = "","") =if(and(this cell equals this and this cell equals this display = "","")...
  7. P

    logical test for if statement

    I am trying to age some outstanding checks in an excel formatted 'register'. I have created columns to the right of the data entries for "1 year", "2 years", etc. representing the length of time that the check has remained outstanding. I am trying to write the formula for 2 years, 3 years ...
  8. S

    If Formula ignoring 0, help???

    Hi Guys I have a database that I am using an If formula to determine a result however some cells that have a zero value are throwing my results. Can anyone help please. This is the formula I am using =IF((F4<F$44),"STRESS","OK") Thanks In Advance
  9. M

    IF formula to return blanks

    Hi all, I'm trying to build a formula to return 0,1 or 3 depending on the values entered into C9,D9. Its a football scorecard! However it reurns 1 when the values in C9,D9 are blanks or text. How do I get the formula to ignore the cells when C9,D9 have no scores in yet...
  10. R

    Combining ABS and ISERROR

    I need to modify the statement below to include ISERROR so that it will also display N/A for a variance percentage calculator. Is it possible to insert in this string. Any suggestions are welcomed. =IF(AI34<>0,IF(ABS((Y34-AI34)/AI34*100)>1000,"N/A",((Y34-AI34)/AI34*100)),"N/A")
  11. J

    if formulas

    Im trying to write a formula that calculates progressive values from a single input. If I input Sales in cell A1 I want cell A2 to return the value in A1 if it is <= A1. I then want to set parameters at say 1,000,000 breakpoints for cells A2 - A6. So if Sales in A1 were 3,500,000 then A2 =...
  12. S

    IF Formula, Sum and FALSE

    I am sure the title doesn't help what I am having problems with, but was drawing a blank on what to put. ANYWAY! I am working on an IF Formula to do different things if different cells are True or False. This is what I have so far...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...