+ Reply to Thread
Results 1 to 2 of 2

Combining two formula

  1. 04-02-2012, 06:40 AM #1
    FooFighter616
    FooFighter616 is offline
    Registered User
    Join Date
    04-02-2012
    Location
    Exeter
    MS-Off Ver
    Excel 2003
    Posts
    14

    Combining two formula

    Currently I have this formula "=IF(L181<2400,$M$180*H181/$B$255,0)". The cell B255 contains the formula "=SUMIF(L$181:L$234,"<2400",$H$181:$H$234)".

    Basically, I want to cut out the cell B255 and have the whole thing in one formula. Is this possible and how would I do this?

    Thanks
    Reply With QuoteRegister To Reply
  2. 04-02-2012, 07:03 AM #2
    darknation144
    darknation144 is offline
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: Combining two formula

    =IF(L181<2400,$M$180*H181/(SUMIF(L$181:L$234,"<2400",$H$181:$H$234)),0)

    That should work
    If someone helped give them rep using the star button.

    If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1