Results 1 to 3 of 3

If Statement

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-05-2010
    Location
    New York
    MS-Off Ver
    Excel 2016
    Posts
    747

    If Statement

    I am having trouble constructing a IF statement with the following characterisitics. The formula should start in Z7 and drag down the column. Can someone please help me? Thanks

    If AC7 = New York and D7 = Buy then add 0.01 to M7
    If AC7 = New York and D7 = Sell then subtract 0.01 from M7
    If AC7 = NASDAQ GS and D7 = Buy then add 0.012 to M7
    If AC7 = NASDAQ GS and D7 = Sell then subtract 0.012 from M7
    Attached Files Attached Files
    Last edited by rhudgins; 03-04-2011 at 11:43 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1