Formula too long (If)

[hurriance]

I get a column of school name and want to use this column to determine
the goodness of a school. i.e.

=if(OR(a1="...",a1="......",.................,a1="......"),"Goo
School","Bad School")

However there are too many schools in that column, so when I paste th
equation to a cell, an error message occur: formula too long.

How can I solve it

 

[Pete_UK]

You could have a separate two-column table made up of a list of all
your schools and against them "Good" or "Bad", and then use a VLOOKUP
formula to return Good or Bad. For Example, if your table occupies L1
to M50, the following formula in B1 would look at a school in A1 and
return what you want:

=VLOOKUP(A1,L$1:M$50,2,0)

Hope this helps.

Pete

 

[Marcus Fox]

I get a column of school name and want to use this column to determine
the goodness of a school. i.e.

=if(OR(a1="...",a1="......",.................,a1="......"),"Good
School","Bad School")

However there are too many schools in that column, so when I paste the
equation to a cell, an error message occur: formula too long.

How can I solve it?

As an addition to what was already posted, you can only use seven nested IF
functions.

Marcus