More than 7 IF? any substitute?
Jean wrote...
looks like excel 2003 limits nested IF for like 10, and i need to
use IF(IF(.....) 15 times. Do you guys know what it could be a
substitute, excel says use Lookup but my data is in a drop down
list build by Validation Data,
Unclear, but lookup is still the most likely way to accomplish this.
Hard to say for sure without more details from you.
|