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
|