More often than not, tasks that seemingly need a chain of (nested) IFs
can be re-expressed as a lookup task.

Christopher Anderson wrote:
How many "if" statements can I include into each formula? I can only seem to
get about 9 and then it gives me an error message. Is there a better way to
do conditional statements that have several conditions?

Thanks

Christopher