+ Reply to Thread
Results 1 to 3 of 3

IF statement in need of improvement to evaluate more criteria

  1. #1
    Registered User
    Join Date
    10-31-2006
    Posts
    61

    IF statement in need of improvement to evaluate more criteria

    Hi All,

    I have attached an updated example of what I am trying to achieve, and have re-worded my description of the problem. There are three tabs, the first showing that my the final result (cell C79) is correct when no cost increases hit against the project. The final award of $89,000 plus $13,500 of contingency leaves me with $897,650 from my $1M budget.

    Sheet two shows that when I now add a $50,000 change order to either column C or D the 50K and its associated contingency of $7,500 is not being reduced to show my that my remaining authority should be $840,150 . Please note that if I was simply to add the $50,000 to column E in this example everything would work fine, however I can't do that b/c column E must match an accounting file, so I need to be able to plug it into column C or D and then once on contract reflect it in column E.


    Sheet 3 shows the desired end state by overwriting the formulas (highlighted) in columns G and L so that it forces it work in cell C79 by showing remaining authority of $840,150.

    The formulas as developed in G & L have worked otherwise, so I would like to keep their intent other than this headache....

    Again any and all help is appreciated.

    Thx.

    Chris

    CMO_LA_BMAR_APPROVAL_TRACKING)_FY16REV2.xlsx
    Last edited by waternut; 08-04-2016 at 03:36 PM. Reason: adding clarification

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: IF statement in need of improvement to evaluate more criteria

    Hey, so we can likely help but we need a clear example of what you are trying to do. Can you show us where you want a formula, what you want it to do by hard coding or hand typing in the EXPECTED result?
    Try to be as succinct as possible, and pick ONE problem at a time.


    Instructions below.
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    10-31-2006
    Posts
    61

    Re: IF statement in need of improvement to evaluate more criteria

    Hi MikeTRON,

    I hope re-working the post provides some clarity to my original inquiry

+ 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. If statement to evaluate the next record...
    By nessabell3 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-19-2013, 03:12 AM
  2. Pivot table improvement and formula improvement
    By constructionsheets in forum Excel General
    Replies: 0
    Last Post: 10-22-2011, 07:06 PM
  3. Why does range evaluate to nothing following set statement
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-07-2011, 11:06 AM
  4. Why does range evaluate to nothing following set statement
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2011, 07:43 AM
  5. Use evaluate instead of range in VBA IF statement
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-29-2010, 06:01 PM
  6. Evaluate:IF statement
    By billansley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2005, 02:05 PM
  7. [SOLVED] Select Case Statement does not evaluate
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-06-2005, 07:06 PM

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