+ Reply to Thread
Results 1 to 4 of 4

Multiple Formulas? Linking conditions...

  1. #1
    Registered User
    Join Date
    07-29-2014
    Location
    Pickering, Ontario
    MS-Off Ver
    2013
    Posts
    4

    Multiple Formulas? Linking conditions...

    Hi guys,

    I'm looking for a formula that links different conditions together.

    For example, I'm entering the formula into G9 and I want the formula to be if G7 is equal or greater to G16 then the answer should be 30, if not then the answer is 0.

    Simple enough I know this is my formula to use "=IF(G7>=G16,30,0)" but I want it to look past that.

    Basically I want it to say if G7 is equal or greater to G16 then the answer is 30, if not it's 0 BUT if G7 is equal to greater than G17 my answer is 60 BUT if my answer is equal to or greater than G18 my answer is 120.

    G17 will always be a larger number than G16, and G18 will always be a larger number than G17.

    Does that make any sense at all?

    Thanks,
    V
    Last edited by vstergianis; 07-29-2014 at 12:14 PM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Multiple Formulas? Linking conditions...

    =if(g7>=g18,120,if(g7>=g17,60,if(g7>=g16,30,0)))

  3. #3
    Registered User
    Join Date
    07-29-2014
    Location
    Pickering, Ontario
    MS-Off Ver
    2013
    Posts
    4

    Re: Multiple Formulas? Linking conditions...

    You are wonderful!!

    Thank you for your help

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Multiple Formulas? Linking conditions...

    Happy to help.

    Don't forget to mark the thread as SOLVED.

    BSB.

+ 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] Dynamic Count and Sum Array Formulas Based on Multiple Conditions
    By 5150 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-27-2014, 04:35 PM
  2. [SOLVED] Formulas with Multiple Conditions
    By xWeen82x in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-14-2013, 02:50 AM
  3. formulas:Linking multiple worksheets
    By Ralph in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-14-2005, 06:32 PM
  4. Need Formulas for counting multiple conditions
    By OrdOff in forum Excel Formulas & Functions
    Replies: 37
    Last Post: 09-06-2005, 12:05 PM
  5. Replies: 1
    Last Post: 08-25-2005, 03:43 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