+ Reply to Thread
Results 1 to 3 of 3

Create "IF formula" that refers to a cell that contains a formula?

Hybrid View

  1. #1
    Registered User
    Join Date
    12-26-2013
    Location
    USA
    MS-Off Ver
    O365
    Posts
    10

    Create "IF formula" that refers to a cell that contains a formula?

    I am trying to create an IF formula that works with the following parameters:

    A1= 20
    A2= (A1*.5)
    A3=X

    I've written a formula for A4 that does not work as I'd like: =IF(A3="X","A2*1.1",0)
    The desired function for cell A4 is if A3 is X, then the value in A4 is (A2*1.10) which should equal 11. However, this formula as I've written it results in "A2*1.1" reporting the cell as text but without the calculation taking place. Is there a way to make the formula in cell A2 calculate values I need while inside the formula in A4 so it reports back the value "11" instead of "A2*1.1"?

    Thanks

  2. #2
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: Create "IF formula" that refers to a cell that contains a formula?

    If you want "11" to show up in cell A4, then use this formula in cell A4:

    =IF(A3="X",A2*1.1,0)
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2504
    Posts
    13,631

    Re: Create "IF formula" that refers to a cell that contains a formula?

    Just remove the double quotes =IF(A3="X",A2*1.1,0)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2013, 05:36 PM
  2. [SOLVED] Cell Formula to count time with "Greater Than or Equal to" and "Less Than"
    By chriswhite1982 in forum Excel General
    Replies: 3
    Last Post: 06-16-2013, 12:30 AM
  3. [SOLVED] Excel formula which refers to "current row"
    By fsinclaire in forum Excel General
    Replies: 2
    Last Post: 05-03-2012, 10:59 AM
  4. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  5. How HardDisk neme "N" or "?" (as cell value) insert into macro formula?
    By frenic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-14-2008, 08:40 AM

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