+ Reply to Thread
Results 1 to 4 of 4

How to return a specific formula calculation if specific text is enterd in another cell

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to return a specific formula calculation if specific text is enterd in another cell

    I have tried searching for this solution for ages without any luck yet.

    Example:
    In cell H1 I want the formula calculation to return F1-G1 "IF" E1 has "Buy" entered, OR H1 to return G1-F1 if E1 has "Sell" entered.

    I am sure there is a way of doing this but have had to resort to this post.

    Thanks in advance

    Zeb

  2. #2
    Registered User
    Join Date
    06-14-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: How to return a specific formula calculation if specific text is enterd in another cel

    =IF(E1="buy",F1-G1,If(E1="sell",G1-F1))

    Returns FALSE if the E1 says neither buy or sell

  3. #3
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: How to return a specific formula calculation if specific text is enterd in another cel

    yeh dats ryt Peter.M is correct

    Even You can use combo box from developer tab for your Buy & sell option no one have to enter it each time simply link it to some cell and replace the"buy" & "sell"in Peter.M formula with 1 & 2.. done enjoy.

  4. #4
    Registered User
    Join Date
    06-20-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to return a specific formula calculation if specific text is enterd in another cel

    Many thanks for that Peter & San and for the quick response, appreciated.

    Kind regards

    Zeb

+ Reply to Thread

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