Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CANNOT GET SECOND CHECKBOOK REGIATER TO DO MATH, wHY? | Excel Worksheet Functions | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
adding days | Excel Discussion (Misc queries) | |||
Rounding Error when adding or subtracting two cells | Excel Worksheet Functions | |||
help neede with adding times | Excel Discussion (Misc queries) |