Excel should have a simpler subtraction formula similar to "sum".

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I think that MS EXCEL 2003 should have a simpler formula to subtract numbers
versus it's current one that requires a minus sign after every cell
reference. The formula should be similar to the function that's performed
with the "sum" function. An example of this forula would look like this:
=diff(A2:A40), instead of it's current syntax which is =A2-A3-A4............
This would allow for the subtraction of a wider range of cells in less time.
 
I think that MS EXCEL 2003 should have a simpler formula to subtract numbers
versus it's current one that requires a minus sign after every cell
reference. The formula should be similar to the function that's performed
with the "sum" function. An example of this forula would look like this:
=diff(A2:A40), instead of it's current syntax which is =A2-A3-A4............
This would allow for the subtraction of a wider range of cells in less time.
Click to expand...

You could easily write a UDF in VBA; or you could do something like:

=A2-SUM(A3:A40)


--ron
 
You could easily write a UDF in VBA; or you could do something like:
=A2-SUM(A3:A40)
Click to expand...

Now I wonder how long it would take you to decide which one you'd choose
Ron....... <g>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error with sum formula in excel 2007 4
formula in excel 2
Creating a formula relating to several cells 2
SUM formula (sort of) 1
Formulas in a cell 2
excel 2003 subtract function 2
Help Creating Excel Formula 4
Sum and Percentage Question... 2

Back
Top