G
Guest
hi,
I have c column in my spreadsheet with a formula in it like:=E8+F8-D8 IN C8
CELL.
E8 and F8 are change manually resulting changes in availability(C8) but the
content of D8 comes from another source and it's change off an on.the problem
is ,say E8=10, F8=20 and D8=12 ,so the C8 comes to 18; now when the D8
changes to 8, the C8 changes to 22 but what I need is maintaining the
previous quantity as 18 and after D8 is turned to 8, the new C8 be 10.
I hope I was able to convey my problem clearly to you.
colu. A col. D
col. E col. F
=E8+F8-D8 (=18) =xx(=12)
10 20
=22 but i need (18-8=10) (now if xx=8)
so is there any way to keep the previous qnty constant?!!
thanx for your time.
I have c column in my spreadsheet with a formula in it like:=E8+F8-D8 IN C8
CELL.
E8 and F8 are change manually resulting changes in availability(C8) but the
content of D8 comes from another source and it's change off an on.the problem
is ,say E8=10, F8=20 and D8=12 ,so the C8 comes to 18; now when the D8
changes to 8, the C8 changes to 22 but what I need is maintaining the
previous quantity as 18 and after D8 is turned to 8, the new C8 be 10.
I hope I was able to convey my problem clearly to you.
colu. A col. D
col. E col. F
=E8+F8-D8 (=18) =xx(=12)
10 20
=22 but i need (18-8=10) (now if xx=8)
so is there any way to keep the previous qnty constant?!!
thanx for your time.