i have a budget of £1500 and need to subtract from it at regular intervals throughout the year so i know how much i have left .
2007-03-27 07:17:19 · 3 answers · asked by flaked_rice 1 in Computers & Internet ➔ Software
you need to enter an equation into one of the "cells". First type the equals sign, so that Excel recognises it as an equation and then type "1500-x" (x is whatever the amount is that is needed to be taken off)
2007-03-27 07:26:14 · answer #1 · answered by mcdonaldcj 6 · 0⤊ 0⤋
Easy peasy pick a column e.g. A format it as currency and as a safety check choose - numbers in red, format column B as date. In cell A1 enter £1500 and in cell A14 (or so) enter =sum(A1:A13) and then when you have to spend some of your money, enter in the A column -£100 (or whatever) and the date in B and Bobs your uncle.
2007-03-27 14:30:37 · answer #2 · answered by ♣ My Brainhurts ♣ 5 · 0⤊ 0⤋
I can send you an Excel spreadsheet with all the formulae written onto to it. It is fairly easy to do but sometimes easier to send than explain. Let me know where to send it to.
2007-03-27 14:32:00 · answer #3 · answered by Taryn H 2 · 0⤊ 0⤋