if statement

  1. C

    Solved Excel macro or formula to autofill cells

    This is just a curiosity post since I've been working a lot with excel lately. Is there anyway to create an IF formula to autofill cells based on a start date and then stop autofilling them on an end date? That probably seems really vague, so I'll attach an example. In my spreadsheet, I have...
  2. J

    Solved Formula Help - &IF

    I am currently pulling data from another worksheet in my workbook and subtracting the previous month's totals from the current month's totals to get the total new items (Jan totals 1100 & Feb totals 1,200 = 100 new items gained from Jan to Feb) =Totals!E4-Totals!D4 (this formula is working...
  3. duvdevan

    Solved Excel Mac 2011 - Functions - IF statement

    I have 2 sheets on my workbook what I want to do is compare (Sheet2)C = (Sheet3)V and if the result is true then copy (Sheet2)D text into (Sheet3)W. =IF(V2=Sheet3!C2, Sheet3!D2, "") but the result I had is always FALSE or "" Columns C and V are numbers Sheet2 C...