Limit amount of times function performs

[boyd]

Hi is it possible and if so how to limit the amount of times a function is performed.

I have a spread sheet and in one column is =A1+(HOUR(A1)=12)/48
I need to get it so that will only perform this function once
and after it has been performed ignore all other instances

Thanks

[DonkeyOte]

You could possibly use Iteration with Max Iteration set to 1 (see Calculation Options)

Please Login or Register  to view this content.

Else you would need to use some VBA (Change event presumably based on range A) to return the above as a Value as opposed to a Formula.

[boyd]

many thanks
will have a play with your solution as VBA is way over my head

[boyd]

Hi DonkeyOte
could you put that code on an example for me as I have been trying and it says circular reference

Sorry not to good at this

[DonkeyOte]

As advised you must enable Iteration (to permit Circular references) -- set Max Iteration to 1... Iteration is set via Options but without knowing your version I can't give specifics (as in 2007 things are laid out a little differently)

[boyd]

Ah I see what you mean but now that means that no other calculations on sheet work