+ Reply to Thread
Results 1 to 2 of 2

If then formula help (If Value is Higher than an identified cell, then other cells populat

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    If then formula help (If Value is Higher than an identified cell, then other cells populat

    Hello all. Thank you in advance for any assistance you may be able to provide.

    I am trying to determine how to great a formula for cells E5, E6 of the attached (in pink) that says if the value of the cell above (E4) is equal to or Greater than the value of cell E10, the cell will perform the formula that I already have in E5, E6.

    Not sure if that makes sense. But what I'm trying to do is create a 5 year investment plan whereby the worksheet automatically inputs those values for me if the balance is above our minimum reserve. That way I can play with the default assumptions and see how it changes throughout the worksheet.

    Again, many thanks for any help you can provide. Cheers...
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: If then formula help (If Value is Higher than an identified cell, then other cells pop

    May be this.....

    Please Login or Register  to view this content.
    You can replace "N/A" with the value when the logical condition evaluates to be false.

    Does it help?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ 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] How do I make a date in a drop down menu populat other cells with folloeing days
    By Eddie Elvis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-13-2013, 11:19 PM
  2. Replies: 2
    Last Post: 05-31-2010, 03:23 PM
  3. Replies: 26
    Last Post: 11-17-2009, 05:32 PM
  4. Can cells containing linked formulas be identified?
    By CLR in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Can cells containing linked formulas be identified?
    By EA in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 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