ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Math (https://www.excelbanter.com/excel-discussion-misc-queries/101021-math.html)

Curtis

Math
 
I am trying to do ways of adding, like if cell is a1=500, b1=500,
c1=500 then on cell f1 has column down to f8 with numbers like first cell
f1=65, f2=100 on down to f8, then next column over g1 to g8 has formula of
subtract of f1 from a1 which is 435, then g2 has f2 subtract from a1 then its
335, now ? is if g6 show 0 or -0 I want it to pick up cell b1 from a1 and
keep on
subtracting till last cell is completed like g8 is last cell with out going
below 0 or -20. So lets say F1 to F8 are numbers I put to take away numbers
in A1 if A1 reach to zero I need to keep subtracting from B1 until last cell
in F8 reach last count.



All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com