# Thread: Help with a formula

1. ## 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. 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. Wow....nothing like making something harder than you need to....Thanks

5. Alternately, iIn H2 enter the formula =IF(L2="",M2*N2,L2*N2) then copy down

Currency.png

HTH,
Maud

6. How about in H2 =(L2*N2)+(M2*N2) then copy down. One of the terms will be equal to zero

Alexandra

7. Sorry Paul. It seems I just duplicated what you posted

8. 0r =SUM(L2*N2,M2*N2)

9. 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
•