Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Nov 2014
    Posts
    11
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Help with a formula

    Excel.jpg

    I am trying to figure out a formula to calculate from two different cells.

    I want Banked to change when I change Banked Hours or Owed Hours.

    Banked is calculated by Hourly rate x Banked hours or Owed Hours.

    Banked hours is always going to be negative and Owed is always going to be positive.

    I tried the following =if(L4<.01, L4*N4, M4>.01, M4*N4) This worked but only in the Banked hours column.

    I want it to work when I change the number in either the Banked Hours or Owed Hours columns

    Thanks

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Why not just add the lot?
    In H4
    =L4*N4+M4*N4

    cheers, Paul

  3. The Following User Says Thank You to Paul T For This Useful Post:

    Split2874 (2014-11-24)

  4. #3
    New Lounger
    Join Date
    Nov 2014
    Posts
    11
    Thanks
    4
    Thanked 0 Times in 0 Posts
    Wow....nothing like making something harder than you need to....Thanks

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    Alternately, iIn H2 enter the formula =IF(L2="",M2*N2,L2*N2) then copy down

    Currency.png

    HTH,
    Maud

  6. #5
    Star Lounger
    Join Date
    May 2013
    Posts
    59
    Thanks
    34
    Thanked 6 Times in 6 Posts
    How about in H2 =(L2*N2)+(M2*N2) then copy down. One of the terms will be equal to zero

    Alexandra

  7. #6
    Star Lounger
    Join Date
    May 2013
    Posts
    59
    Thanks
    34
    Thanked 6 Times in 6 Posts
    Sorry Paul. It seems I just duplicated what you posted

    How about this then. H2 =(L2+M2)*N2 then copy down
    Last edited by Alouso; 2014-11-24 at 19:01.

  8. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 650 Times in 592 Posts
    0r =SUM(L2*N2,M2*N2)

  9. #8
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,191
    Thanks
    48
    Thanked 986 Times in 916 Posts
    Alexandra, yours was clearer thanks to the brackets. I'm lazy and allow the mathematical laws to do the work.

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •