Formula help
Thank you!
"Ron Rosenfeld" wrote:
On Fri, 1 Aug 2008 15:15:01 -0700, bpa wrote:
I haven't used Excel in a while. I am trying to figure out how to create a
formula to display the result of subtracting different cells in a row. For
example:
n=a1-b1 with result showing in n; then when I update the next time I want
n=b1-c1
and so on for the remainder of the cells in row 1. Is there a way to do
this???
Thanks in advance!
If I understand you correctly, you will be entering numbers sequentially in A1,
B1, C1 etc.
You want the subtraction of the last number entered from the next-to-last
number entered to appear in N1.
I assume the last value would be entered in M1.
That being the case, try this formula:
=OFFSET(N1,0,COUNT(A1:M1)-COLUMN(N1)-1)-
OFFSET(N1,0,COUNT(A1:M1)-COLUMN(N1))
--ron
|