ExcelBanter - Need more than 7 nested "IF" statements in Excel"

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need more than 7 nested "IF" statements in Excel" (https://www.excelbanter.com/excel-discussion-misc-queries/122893-need-more-than-7-nested-if-statements-excel.html)

James A

Need more than 7 nested "IF" statements in Excel"

Is there any way to get more nested "IF" statements than the 7 limit?
--
James A

Bob Phillips

Need more than 7 nested "IF" statements in Excel"

Some ways at http://www.cpearson.com/excel/nested.htm

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

"James A" wrote in message
...
Is there any way to get more nested "IF" statements than the 7 limit?
--
James A

All times are GMT +1. The time now is 06:59 PM.