substract cells from other cells then forwarding to a different ce
 

hi ,this is kiran
my doubt is i have created my excel sheet for updating my household expenses
on monthly based.here i have to substract the total expenses for the month
the total income i keep on adding on different forms i get.so what i want to
know is if i place a name total in the details cell i want excel sheet to
give me the automatic result in the balance cell .so i have cell names as in
order as
amount details received expenditure balance

so here in the middle if i place total as details i should get the balance
as the (received -expenditure) in the balance cell of the same row
Sample sheet appears like this

amount details received expenditure balance

aa
ad
fa
Total 2000 240 1760 so i shuld get this
format of substraction where ever i place the Total as details


hope u understand the question please forward the answers

substract cells from other cells then forwarding to a different ce
 

If "Total" is in Row 5, and "Balance" is in Column E, then in E5 enter:

=C5-D5

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"kiran" wrote in message
...
hi ,this is kiran
my doubt is i have created my excel sheet for updating my household
expenses
on monthly based.here i have to substract the total expenses for the month
the total income i keep on adding on different forms i get.so what i want
to
know is if i place a name total in the details cell i want excel sheet to
give me the automatic result in the balance cell .so i have cell names as
in
order as
amount details received expenditure balance

so here in the middle if i place total as details i should get the balance
as the (received -expenditure) in the balance cell of the same row
Sample sheet appears like this

amount details received expenditure balance

aa
ad
fa
Total 2000 240 1760 so i shuld get
this
format of substraction where ever i place the Total as details


hope u understand the question please forward the answers