Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CANNOT GET SECOND CHECKBOOK REGIATER TO DO MATH, wHY? | Excel Worksheet Functions | |||
Excel Math problem | Excel Worksheet Functions | |||
math | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
How do I do math on a cell name in formula? | Excel Worksheet Functions |