Results 1 to 14 of 14

If when and formula

Threaded View

  1. #1
    Registered User
    Join Date
    05-23-2014
    Posts
    12

    If when and formula

    Hi All,

    I previously submitted a post with a very specific request for formula. I decided to break the procedure in half, as all of my rules will not fit in one calculation cell.

    What I have so far is attached.

    Now, I am looking for a formula that will round to a specific number if two other cells meet the conditions. My parameters are below.

    E9 is to = $1000000, ONLY IF B9= 75%, AND IF C9 is less than $1000000
    E9 is to = $1500000, ONLY IF B9= 70%, AND IF C9 is less than $1500000
    E9 is to = $2000000, ONLY IF B9= 65%, AND IF C9 is less than $2000000

    Both B9 and C9 are formulas, not sure if that makes a difference?

    Please help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Tags for this Thread

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