Hi Brenda,

Do you mean that the formula in N1 will always subtract
the last two values entered in A1 to M1.

If that is the case then try this in N1.
=INDEX(A1:M1,LARGE(IF(LEN(A1:M1)0,COLUMN(A1:M1)), 2))-LOOKUP(1E+100,A1:M1)

That is an array formula and must be comitted by using
Ctrl+Shft+Enter and not just Enter.

As you enter values across row 1 it will update and
only subtract the last two values.

HTH
Martin


"bpa" wrote in message
...
Hi Bernie,
Thank you for answering. Maybe I'm not understanding, or maybe not clear
enough on what I am looking for. I need the result from the calculation
to
be on the same row, i.e. N1 and for the number in N1 to change as I add in
additional values in the same row. I tried your idea and the formatting
flowed properly, but when I added data in the cells going across, the
formatting disappears and the calculations no longer work?? I can always
change the formula in the N column and copy it down to the remainder of
the
rows, but was hoping for an "automated" way!! Maybe wishful thinking on
my
part? Thanks again!
Brenda

"Bernie Deitrick" wrote:

In Cell B2, type

=A1-B1

then copy cell B2 and paste to C2 and so on, to match your last cell in
row
1

HTH,
Bernie
MS Excel MVP


"bpa" wrote in message
...
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!