Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
URL forwarding in Excel? | Excel Discussion (Misc queries) | |||
URL forwarding in Excel? | Setting up and Configuration of Excel | |||
forwarding cell data | Excel Worksheet Functions | |||
How do I substract numbers in range like this: Substract(a1..a10) | New Users to Excel |