Approach User Support homepage Approach User Support
Answers to Frequently Asked Questions about Lotus Approach
Examples LotusScripts
Example databases
Links to other Lotus Approach support services

[Return to contents]

IF limitations in v3.0*

Last updated: before December, 1998

v3.0* allows for a maximum of 30 levels of imbedded IF's e.g.:

FIELD1=IF(x,a,IF(y,b(IF z,c,IF...

To get around this, simply use additional formulae, e.g.:

FIELD1=IF(x,a,IF(y,b(IF z,c,FIELD2)))
FIELD2=(IF(x1,a1,IF(y1,b1,IF(z1,c1...)))

[Return to contents]

© Copyright, JohnBrown, Trademarks, Disclaimer, Acknowledgements.