I need more than 8 IF functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve - 17 Oct 2006 03:25 GMT

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

Reply to this Message

JMB - 17 Oct 2006 03:44 GMT

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

> 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

Reply to this Message

Bob Phillips - 17 Oct 2006 08:55 GMT

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

Signature

HTH

Bob Phillips

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

> 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

Reply to this Message

Fred Smith - 18 Oct 2006 02:15 GMT

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.

Signature

Regards,
Fred

>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

Reply to this Message