#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 181
Default Adding math

I am trying to do a strange ways of adding, like if cell is a1=500, b1=500,
c1=500 then on cell f1 has column down to f5 with formula like first cell
f1=65, f2=100 on down to f5, then next roll over g1 to g5 has formula of
subtract of f1 from a1 which is 435, then g2 has f2 subtract from a1 then its
335, now ? is if g4 show 0 or -0 I want it to pick up b1 from a1 and keep on
subtracting till last cell is completed like g5 is last cell with out going
pass 0 or -20
Reply
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
CANNOT GET SECOND CHECKBOOK REGIATER TO DO MATH, wHY? lynnbuff Excel Worksheet Functions 2 July 21st 06 10:41 PM
Date arithmetic: adding 1 month to prior end of month date manxman Excel Worksheet Functions 2 July 14th 06 09:29 PM
adding days jcool12 Excel Discussion (Misc queries) 4 June 14th 06 09:25 AM
Rounding Error when adding or subtracting two cells mtheo Excel Worksheet Functions 2 February 28th 06 06:51 PM
help neede with adding times rvnwdr Excel Discussion (Misc queries) 1 June 17th 05 02:15 PM


All times are GMT +1. The time now is 04:53 PM.

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

About Us

"It's about Microsoft Excel"