Is there any way around the maximum of seven nested functions?
more info,- what where?
"Nakia Allen" skrev:
I am working on an Excel spreadsheet, but the summary page must check the
information in 10 to 20 cells and once it finds a match, it must become equal
to a value in a different cell. Is there any way to have multiple IF
functions to verify a value when there are more than 7 checks (the maximum
number of nested functions)? FYI, I am comparing data strings.
|