There are many ways round the limit of 7 nested IFs - post an example
of your formula and a more fullsome description of what you want to
achieve, and someone will be able to help you.

Pete

unouwanme wrote:
I am trying to use 10 if statements in 1 cell, but keeps coming up with an
error, but is ok when i delete 2...

Anyone know?