+ Reply to Thread
Results 1 to 3 of 3

Complex IF Statement

  1. #1
    Registered User
    Join Date
    10-04-2008
    Location
    florida
    Posts
    1

    Complex IF Statement

    I am trying to do a complex IF Statement and I cannot figure it out. What I am trying to do is if the IF Statement result is FALSE I want the entire formula to delete so, that I am able to type in that cell. If it is TRUE I want it to calculate a formula. Here is an example of what I what I am trying to do:

    I am creating an estimating spreadsheet and I would like the estimators to pick how they want to come up with the GM & Price. I want them to either enter in the GM they would like to receive and then a unit price will automatically calculate or I would like them to be able to enter in the unit price and then the GM automatically calculates.

    See example below:
    My cost per unit is $200 (cell A1), I want the option to enter a GM (cell A2)of 25% and my unit price (cell A3) automatically calculates to $250 OR I want to be able to enter a unit price in cell A3 and the GM (cell A2) automatically calculates.
    Would this be an IF Statement? Is this going to be a circular reference problem?

    All help is appreciated!!

  2. #2
    Valued Forum Contributor mdbct's Avatar
    Join Date
    11-11-2005
    Location
    CT
    MS-Off Ver
    2003 & 2007
    Posts
    848
    You would have to use code to do what you are looking to do. Please see my reply in this thread.
    http://www.excelforum.com/excel-misc...-in-excel.html

  3. #3
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394
    Why don't you just put a message like "enter data here..." if the result is false? The cell wouldn't be empty, but that doesn't really matter.

+ 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. Complex IF statement question
    By richard_evans in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-20-2008, 01:13 PM
  2. Amending an if statement
    By isolation123 in forum Excel General
    Replies: 27
    Last Post: 03-13-2008, 08:02 AM
  3. IF statement
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-31-2008, 02:21 PM
  4. Complex IF Statement help needed
    By djboggs in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-30-2007, 03:17 PM
  5. Complex If statement formula
    By PeeGee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-30-2007, 05:03 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