LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 65
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel: match two cells in one sheet to two cells in another and return a third cells value Spence Excel Worksheet Functions 3 February 13th 11 05:33 AM
URL forwarding in Excel? tishoo Excel Discussion (Misc queries) 3 December 26th 06 04:36 PM
URL forwarding in Excel? tishoo Setting up and Configuration of Excel 3 December 26th 06 04:36 PM
forwarding cell data Jim Excel Worksheet Functions 5 March 3rd 06 04:31 AM
How do I substract numbers in range like this: Substract(a1..a10) Paulo New Users to Excel 3 November 17th 05 04:48 AM


All times are GMT +1. The time now is 09:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"