Formula

Highlighted
New Contributor

Hi all, wondering if its possible in Excel to setup deductions occurring fortnightly? # in CELL E3 deduct from # in CELL H3.  What I have so far is e.g.

=SUM(H3,-E3) 

The reoccurring total will be in CELL I3

Is this even correct LOL. Cheers

2 Replies
Highlighted

@STRUGGLING  did that work for you?  That will subtract those 2 cells as you as but a more simple formula might be =H3-C3

Highlighted

@mtarler 

Yes it worked and thanks heaps for advice, do you know how to make it recurring twice a month.