Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Nov 2014
    Posts
    5
    Thanks
    1
    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
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,736
    Thanks
    7
    Thanked 241 Times in 229 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
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Wow....nothing like making something harder than you need to....Thanks

  5. #4
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,284
    Thanks
    46
    Thanked 255 Times in 235 Posts
    Alternately, iIn H2 enter the formula =IF(L2="",M2*N2,L2*N2) then copy down

    Currency.png

    HTH,
    Maud

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

    Alexandra

  7. #6
    Lounger
    Join Date
    May 2013
    Posts
    45
    Thanks
    29
    Thanked 4 Times in 4 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
    Bronze Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,284
    Thanks
    46
    Thanked 255 Times in 235 Posts
    0r =SUM(L2*N2,M2*N2)

  9. #8
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,736
    Thanks
    7
    Thanked 241 Times in 229 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
  •