A.I.M. Users Bulletin Board

[Conrad]

Indeed Larry,

IF date<xxx,then Y,otherwise Z.

This is in principle the same as the conditional function with the value of B= 1 or B= 0 in a reference Cell. This approach was suggested to me by Clive, but I would need to reprogram all the cells that need to be "frozen" after a certain date. Once done I could change the date or the reference value as needed.

Still I am looking for an Excel function to do this. . .If I can lock identified cells with one function then it should be easy to freeze identified cells with one function.

I am going to Call Bill Gates later today to make that possible in the next Excel version and sell the idea for 1 million Dollars to him. . .just a pittance to him for an old geezer!!

unless of course if any of you people here are going to call Bill to sell my idea for less. . .then I have to drop my price to below what you are asking