I am tryin gto create a formula but need to use more than 8 IF functions in
it. The program will not allow more but I need more, Can anyone suggest how I
may acheive this please

Thanks

http://www.cpearson.com/excel/nested.htm

"Steve" wrote:

I am tryin gto create a formula but need to use more than 8 IF functions in
it. The program will not allow more but I need more, Can anyone suggest how I
may acheive this please

Thanks

Many solutions, tell us the data and the requirement in detail.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Steve" wrote in message
...
I am tryin gto create a formula but need to use more than 8 IF functions
in
it. The program will not allow more but I need more, Can anyone suggest
how I
may acheive this please

Thanks

You never need more than 7 nested IFs. There's always a better solution,
typically Vlookup or Index. Post your requirements. You'll get lots of
suggestions.

--
Regards,
Fred


"Steve" wrote in message
...
I am tryin gto create a formula but need to use more than 8 IF functions in
it. The program will not allow more but I need more, Can anyone suggest how I
may acheive this please

Thanks