Subtracting Numbers in Cells

**gloom52** · 09-09-2009, 12:33 PM

I have 2 rows in my spreadsheet
A B C
Time Account Entitlement Remainder
1 Other Leave 11 xx
2 Annual Leave 15 xx

What I wants is that if I take a leave it will start deducting from Other Leave first until the "Other Leave" drops to zero then will it start deducting from the "Annual Leave"

**JBeaucaire** · 09-09-2009, 01:05 PM

        A                   B                      C
Time Account           Entitlement            Remainder
1 Other Leave              11                     xx
2 Annual Leave             15                     xx

Originally Posted by gloom52

What I wants is that if I take a leave it will start deducting from Other Leave first until the "Other Leave" drops to zero then will it start deducting from the "Annual Leave"

Sounds good. Click GO ADVANCED and use the paperclip icon to post up your workbook. We can suggest something when we see where/how you want these calculations in regard to where you're "taking a leave".

Make sure your sample workbook includes all the information about where you indicate leave.

**gloom52** · 09-09-2009, 03:14 PM

heres the attachment a bit messy but I've placed comments on the "Personal Data" and "Aug09" sheet so that u could explain the solution a bit more easily.

**JBeaucaire** · 09-09-2009, 08:58 PM

I've streamlined all the formulas in I21:I26 including the two you needed help with. I put a BUNCH of "Leave" entries in AUG09 so you'll want to fix those later.

Also, SEPT09 and NOV09 sheet tabs had extra spaces in the sheet name I had to remove, be careful of those.

**gloom52** · 09-10-2009, 08:30 AM

The formulas worked very well but now there seems to be a new problem..
If I removed all the Leaves, the "Yearly Entitled Leave" remainder becomes zero which should have been the same as the number under "Entitlement"

**gloom52** · 09-10-2009, 08:32 AM

Erm forget this last post. I've managed to fixed the problem by changing the False section under the "IF" function to the entitled leave and it works well

**JBeaucaire** · 09-10-2009, 01:15 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)