Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
My column B is entitled "No. in Stock". These boxes contain the quantity of a
certain product that we have in stock. My columns E and G are entitled "Used" and "Delivered" respectively. These column are repeated in H and J, K and M etc etc What I want to happen is that when a number is put in E it is subtracted from B and then G is added to B. Is there a shorter way of doing this rather than typing in =(-E5+G5)+(-H5+J5)+(-K5+M5) etc etc because in the row 5 there could be up to 50 different sections Thanks WoodyAccess |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
adding and subtracting using vb code | Excel Discussion (Misc queries) | |||
adding and subtracting columns | Excel Worksheet Functions | |||
formula for adding / subtracting two columns . | New Users to Excel | |||
Rounding Error when adding or subtracting two cells | Excel Worksheet Functions | |||
How to display 5.5 hours instead of 5.30 when adding \ subtracting | Excel Discussion (Misc queries) |