Is it really necessary to go 7 layers deep?

Are there really 128 (2^7) outcomes or just 2 coutcomes?

You might be able to use the AND operator to reduce the layers of IF.

Let us know how you want to proceed?


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"diana" wrote in message
...
I am trying to put 10 nested if statements in a cell. In Excel 2002, it now
only allows 7 embedded if statements. It says I need to make a macro. I
need
step by step instructions. Can you help?