Tanks Clive for the suggestion
Perhaps something like
=IF( $B$1 =1,99,D1+C4)
Possibly it might work in principle.
Normally the object cell contains a formula like say a conditional operation like this:
=ALS(EN(ABS(G15)>=E15*$H$4;G15>0);. . . . =F=Function
The outcome of this is an unknown Quantity =N, and after a certain date this quantity must remain N.
I must enter an extra cel B in which I enter a 1 or a 0 and rewrite the object cell:
=IF( $B$1 =1,Fn,Fn-1)
Object Cell in Colum D
n = is the row number
Nn = the value of the function F(n)
B=…..Cell D
……….D0=N0
0. . .=IF( #B$1 =1,F(1),F(0)) When B=0 the Function is calculated to gives N1 from F(0)=D0
0. . .=IF( $B$1 =1,F(2),F(1)) When B=0 the Function is calculated to gives N2 from F(1)=D0
0. . =IF( $B$1 =1,F(3),F(2)) When B=0 the Function is calculated to gives N3 from F(2)=D0
1. . .=IF( $B$1 =1,F(4),F(3)) When B=1 the Function is calculated to gives N4 from F(4)=D4
1. . .=IF( $B$1 =1,F(5),F(4)) When B=1 the Function is calculated to gives N5 from F(5)=D5
So Cell D(n) retains the value of Cell D(n-1) as long as B=0. Essentially if B=0 I would copy the value of the cell above. . . .I think this would work,.. .interesting solution.
When B=1 the Function in Cell C is calculated as usual.
But this extra conditional statement is nothing different than the conditional function I already programmed. . .I should have realised this myself!!
But in order to do this I would have to rewrite all the cells that need to be frozen after a certain date. . .and that I wanted to avoid.
I would have thought there might be standard management feature in Excel that with highlighting the cells the target Cells all the values would be fixed as numbers and all the functions would be frozen. This works the same as with blocking the cells. . .but with blocking the function itself still work as usual.
Manually entering the fixed values is no option. . .but you gave me an idea with this! This could work.
If I copy the Cells and paste them on Word then only the values are pasted as well as the cells!!!!! I then copy these cells from Word and paste them back in Excel, and only the values are pasted!
That will work!
Thanks for that hint Clive!
