subtraction formula

Is there a general formula to subract the two previous boxes?
I don't want to go though slowly

Depends what you mean by "boxes" and "previous".

NickHK

"Durzan" <[email protected]> wrote in
message news:[email protected]...
>
> Is there a general formula to subract the two previous boxes?
> I don't want to go though slowly
>
>
> --
> Durzan
> ------------------------------------------------------------------------
> Durzan's Profile:
http://www.excelforum.com/member.php...o&userid=37447
> View this thread: http://www.excelforum.com/showthread...hreadid=571142
>

eg.
Houses
Income | Fee's | difference
1,000 | 800 | 200
1,500 | 1,600| -100

something to calculate that but instead of ahaving to select each coordinate seperately.

suppose A1 is "income" , B1 as "Fees" and C1 "difference"
type in C2
=a2-b2
copy c2 down.


"Durzan" <[email protected]> wrote in
message news:[email protected]...
>
> eg.
> Houses
> Income | Fee's | difference
> 1,000 | 800 | 200
> 1,500 | 1,600| -100
>
> something to calculate that but instead of ahaving to select each
> coordinate seperately.
>
>
> --
> Durzan
> ------------------------------------------------------------------------
> Durzan's Profile:
> http://www.excelforum.com/member.php...o&userid=37447
> View this thread: http://www.excelforum.com/showthread...hreadid=571142
>