I have an amount eg 100 want each payment to be deducted from this. I have wrote =a1-a2-a3-a4-a5-a6 this works however will get to long. how do I write this in a formula? thanks

If you are talking about some kind of spreadsheet try =a1-sum(a2..a3000). If not, please tell us what kind of program you are working with. Nigel

Wind slow

It would have been better to place this post in the Office Software Forum rather than here. You have to be a little bit crazy to keep you from going insane.

I've seen lots of posts over the years asking how to do something

in Excel, where the poster seems to assume that Excel is the only

thing anyone would be asking about here. Is there a reason?

Maybe somebody gives a link to this forum saying that questions

about Excel (or Office) should be asked here?

-- Jeff, in Minneapolis

Ask Your Question

Weekly Poll