+ Reply to Thread
Results 1 to 11 of 11

Combining two IF formulas

  1. #1
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Combining two IF formulas

    Hi,

    Is it possible to combine the following two formulas:

    =ROUNDDOWN(IF(D12<60,1010,1210)/B6,0) & =IF(D13<D7,1000000)

    Any help would be appreciated.

    Thanks.

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Combining two IF formulas

    Is the first ROUNDDOWN formula in D13?

    Are you then checking the outcome of this against D7?

    Sorry, I just want to make sure that I've got the logic correct
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

  3. #3
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Re: Combining two IF formulas

    Hi, I've attached the file. It's the workings sheet that I'm looking at.

    Thanks.
    Attached Files Attached Files

  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
    79,359

    Re: Combining two IF formulas

    How about this?

    =IF(ROUNDDOWN(IF(D12<60,1010,1210)/D12,0)<D7,1000000,ROUNDDOWN(IF(D12<60,1010,1210)/D12,0))
    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.

  5. #5
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Combining two IF formulas

    Thanks for the file.

    So If GRADE is HD, you want to divide SLABS by 2,500, then divide by LENGTH
    and if GRADE is LD, you want to divide SLABS by 2,440, then divide by LENGTH
    and if GRADE is neither of these, you want the answer in VOLUME to be 1,000,000

    Just want to be sure that's the correct logic - it comes out with a very very small number!

  6. #6
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Combining two IF formulas

    Hi,
    Even with your File I cannot understand exactly what you want
    Can you explain in words carefully what you want the final formula to do
    Thanks
    Alan
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

  7. #7
    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
    79,359

    Re: Combining two IF formulas

    I'm not sure that the OP is having an issue with the result of either formula: he (she?) just seems to want to combine them into one. We shall have to await his (her?) return to see who's right, however.

  8. #8
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Re: Combining two IF formulas

    Thanks for the help and that works perfectly. I also need to combine the following formulas I've tried to replicate from your formula but failed. Any help would be appreciated:

    =ROUNDUP(H12/F13,0) & IF(D13<D7,1000000))

    The formula needs to go in cell I13 on the workings sheet.

    Thanks

  9. #9
    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
    79,359

    Re: Combining two IF formulas

    Try this:

    =IF(D13<D7,1000000,ROUNDUP(H12/F13,0))

  10. #10
    Forum Contributor
    Join Date
    05-14-2015
    Location
    West Yorkshire
    MS-Off Ver
    10
    Posts
    130

    Re: Combining two IF formulas

    Again perfect thank you. Sorry to be a little vague but I'm trying to calculate a manual process for the shop floor that has allsorts of funny quirks...

    Thanks.

  11. #11
    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
    79,359

    Re: Combining two IF formulas

    You are very 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. Combining IF AND formulas
    By hzarry in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-07-2015, 05:26 AM
  2. combining two formulas
    By taker418 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 06-07-2013, 01:18 PM
  3. [SOLVED] Combining IF formulas
    By nav505 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-05-2013, 01:24 PM
  4. Too many IFs - combining few formulas into one - need help
    By vemix in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-24-2013, 01:42 PM
  5. Combining three formulas
    By neil676 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-17-2009, 09:44 AM
  6. [SOLVED] combining formulas
    By Sherri in forum Excel General
    Replies: 3
    Last Post: 07-19-2006, 05:35 PM
  7. [SOLVED] need to Combining formulas
    By Krista in forum Excel General
    Replies: 11
    Last Post: 06-26-2006, 10:15 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