substract cells from other cells then forwarding to a different ce

K

kiran

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top