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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top