Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

You get very high flexibiity defining calculated validity ranges with the help of OFFSET. Any validation depending on the content of some other cells is logically doubtable, however. A formerly valid content (selected from dropdown e.g.) will persist a change of a cell the validation should depend on. This despite the fact that it is possibly no longer validl.

If you need reliable validadition this may not be the appropriate approach.

(Example attached:) ask48657ValidityTree001.ods

You get very high flexibiity defining calculated validity ranges with the help of OFFSET. Any validation depending on the content of some other cells is logically doubtable, however. A formerly valid content (selected from dropdown e.g.) will persist a change of a cell the validation should depend on. This despite the fact that it is possibly no longer validl.

If you need reliable validadition this may not be the appropriate approach.

(Example attached:) ask48657ValidityTree001.ods

You get very high flexibiity defining calculated validity ranges with the help of OFFSET. Any validation depending on the content of some other cells is logically doubtable, doubtable, however. A formerly valid content (selected from dropdown e.g.) will persist a change of a cell the validation should depend on. This despite the fact that it is possibly no longer validl.

If you need reliable validadition this may not be the appropriate approach.

(Example attached:) ask48657ValidityTree001.ods