how to write a formula

November 12, 2015 at 08:08:54
Specs: Windows 7
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


See More: how to write a formula

Report •

#1
November 12, 2015 at 09:53:23
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


Report •

#2
November 12, 2015 at 19:32:37
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.


Report •

#3
November 13, 2015 at 01:45:01
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


Report •
Related Solutions


Ask Question