formula for if

  1. T

    Simple formula needed

    Hi, I believe I need an "IF" formula to figure out the % of target achieved for stock trading. If a LONG trade: I purchase 100 shares at $49 and my target is $52, then I sell at $51.50, what is the % of target achieved? If a SHORT trade: I Short 100 shares at $49 and my target is $46, then I...
  2. caritx

    Formula Question

    I have the following data in Columns A and B and I want C to be my formula. Column A------- Column B 4152 -------------Y (blank) ------------N 1524 --------------N (blank)-------------...
  3. A

    Challenging IF task with proximity

    I've been working on this for over a day straight now, including hours of reading threads on here and can't figure out if it's even possible. Hopefully someone has a thought on it here. I'm trying to look in another file at two sets of numbers that are unique in thousands of rows. If both of the...
  4. D

    IF statement, involving dates

    I'm attempting to create a formula using dates where the outcome is determined on data within a cell.. If the date within cell AF4 (and all cells within that column) takes place before 01/01/1987, "C" needs to populate in AG4. On 01/01/1987 and after, "F" should populate in cell AG4. I...
  5. E

    Rookie IF Question

    Hello Here is what I am trying to do, perhaps someone can guide me? Cell A1 is a drop down list to choose between 2 options- Cats or Dogs. whichever you choose will drive the answers below. If you choose either one- Cats or Dogs, it pulls data from other cells and populates cells A2 and A3...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top