+ Reply to Thread
Results 1 to 4 of 4

Combining multiple formulas into 1

  1. #1
    Guest
    Join Date
    12-15-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    7

    Combining multiple formulas into 1

    Hi guys, I need some help with coding please. I've attached the file here for ease of reference.

    A few steps are involved and I'm trying to get it all in 1 step:

    1. I want to establish, the highest value in column F1, rows 4-12.

    2. Thereafter I want to identify the corresponding colour of row 12 (mentioned in column G1).

    3. If the colour is Red, I want 2 separate values:
    i) (Row 12, Column E) minus the value obtained in step 1 = "Red Sale"
    ii) (Row 12, Column B) plus the value obtained in step 1 = "Red Buy"

    4. If the colour is Green, I want 2 separate values:
    i) (Row 12, Column B) minus the value obtained in step 1 = "Green Sale"
    ii) (Row 12, Column E) plus the value obtained in step 1 = "Green Buy"

    I'm computing these tables for work and there's hundreds of them! I've done one example of the intended output (just manually coding each step) but any help getting it in 1 step (yellow box) would be most appreciated!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Combining multiple formulas into 1

    J19: =IF($J$9="Red",E$12-MAX($F$4:$F$12),"")
    J20: =IF($J$9="Red",B$12+MAX($F$4:$F$12),"")
    J22: =IF($J$9="Green",B$12-MAX($F$4:$F$12),"")
    J23: =IF($J$9="Green",E$12+MAX($F$4:$F$12),"")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Guest
    Join Date
    12-15-2015
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    7

    Re: Combining multiple formulas into 1

    Thanks for the help!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Combining multiple formulas into 1

    You're most welcome!

+ 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] Combining multiple formulas
    By johnmitch38 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-20-2015, 06:00 AM
  2. [SOLVED] Combining multiple IF/AND formulas
    By matt1020 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-26-2014, 01:55 PM
  3. combining multiple if formulas
    By AD2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2013, 01:11 PM
  4. [SOLVED] Combining multiple formulas in one cell
    By scsuflyboy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-11-2012, 11:47 AM
  5. Combining multiple formulas. I think it is easy.
    By Janstoop in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-05-2011, 07:04 AM
  6. Combining Multiple IF/THEN Formulas
    By artiststevens in forum Excel General
    Replies: 3
    Last Post: 12-09-2010, 07:05 PM
  7. Combining multiple formulas
    By rlkerr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-30-2006, 03:39 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