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

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.

On Sat, 19 Feb 2005 09:31:02 -0800, Darius
wrote:

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.

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

=A2-SUM(A3:A40)


--ron

Will =a2-sum(A3:A40) answer the problem ?
Ilan

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

=A2-SUM(A3:A40)

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ron Rosenfeld" wrote in message
...
On Sat, 19 Feb 2005 09:31:02 -0800, Darius

wrote:

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.

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

=A2-SUM(A3:A40)


--ron

On Sun, 20 Feb 2005 02:46:01 -0000, "Ken Wright"
wrote:

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

Well, the OP did ask for a function! <bg


--ron

rotflmao :-)

--
Regards
Ken.......................


"Ron Rosenfeld" wrote in message
...
On Sun, 20 Feb 2005 02:46:01 -0000, "Ken Wright"
wrote:

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

Well, the OP did ask for a function! <bg


--ron